After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 704742 - Graph imported incorrectly/partially from ods file
Graph imported incorrectly/partially from ods file
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other Linux
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2013-07-23 13:14 UTC by jutaky
Modified: 2013-07-23 21:59 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample case (14.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-07-23 13:14 UTC, jutaky 		Details

Description jutaky 2013-07-23 13:14:57 UTC 
Created attachment 249889 [details]
sample case

I don't know if this is a bug or a lack of feature. But the graph, which is drawn from multiple ranges/cells in this ods file, is not completely imported in Gnumeric.
Comment 1 Andreas J. Guelzow 2013-07-23 16:24:43 UTC 
It really comes down to the interpretation of 

<chart:series chart:style-name="ch7" chart:values-cell-range-address="Sheet1.A2:Sheet1.A4 Sheet1.A6:Sheet1.A6 Sheet1.A9:Sheet1.A9 Sheet1.A14:Sheet1.A14 Sheet1.A22:Sheet1.A22" chart:label-cell-address="Sheet1.A1:Sheet1.A1" chart:class="chart:bar">

According to ODF 1.2 "The chart:values-cell-range-address attribute specifies a cell range that contains the values for a data series." and "The chart:values-cell-range-address attribute has the data type cellRangeAddressList 18.3.6.".

I believe we currently just expect a single cellRangeAddress rather than a cellRangeAddressList.
Comment 2 Andreas J. Guelzow 2013-07-23 16:29:01 UTC 
The tricky part is that we don't see support for series combined from various ranges in goffice.

I guess we could import that list as array(Sheet1.A2:Sheet1.A4 Sheet1.A6:Sheet1.A6
Sheet1.A9:Sheet1.A9 Sheet1.A14:Sheet1.A14 Sheet1.A22:Sheet1.A22) and on export strip the array function again.
Comment 3 Andreas J. Guelzow 2013-07-23 19:24:19 UTC 
I have fixed the import. So the sample file now imports correctly. I still have to fix the export though, and so are keeping this bug open.
Comment 4 Andreas J. Guelzow 2013-07-23 21:48:33 UTC 
We can now export the original file correctly so that it can be opened by LO. There is still the problem that we don't open it correctly...
Comment 5 Andreas J. Guelzow 2013-07-23 21:59:46 UTC 
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.