GNOME Bugzilla – Bug 743818
failure of export of chart data specifications involving formulae
Last modified: 2015-02-07 19:33:29 UTC
Created attachment 295904 [details] sample file Gnumeric exports the data sources in charts to be specified by formulae. ODF does not natively. Currently the ODF exporter in this case creates invalid ODF files, e.g.: <chart:series chart:values-cell-range-address="$'Mixed'.$C$1:.$C$10]*10" chart:style-name="GOG-8" gnm:label-cell-expression=""XY"" chart:class="chart:scatter"> <chart:domain table:cell-range-address="$'Mixed'.$B$1:.$B$10]*10"/> </chart:series> There are several layers of problems here: 1) the ODF files create should be valid. 2) we should still be able to round-trip through extended ODF 3) we might even be able to export to valid ODF readable by other consumers using hidden data sheets inside the chart file. I have attached a sample (uncompressed) gnumeric file using these formulae.
Note that in these cases we also get many criticals on loading our corrupted ODF file and are leaking expressions...
Layer #1 is fixed. Note that #3 still breaks the connection between sheet and graph, so it would not be much better than showing a picture of the original graph. Keeping open for #2.
I'm actually ok with not supporting this for formats not meant to handle it. However, it would be nice to introduce a pre-save call for the GOFileSaver to go over the document and make a list of things that the saver cannot handle.
#2 is now done too. This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.