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 671461 - some chart formatting disappears after save>close>open ods document
some chart formatting disappears after save>close>open ods document
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
1.10.x
Other Linux
: Normal minor
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2012-03-06 13:01 UTC by jeanettedemarius
Modified: 2012-03-25 06:41 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
formatted chart after saving the ods file (top) and after closing and reopen (bottom) (779.16 KB, image/jpeg)
2012-03-06 13:01 UTC, jeanettedemarius
Details
original see 671461.ods file (685.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-06 16:42 UTC, jeanettedemarius
Details
.gnumeric file (83.97 KB, application/x-gnumeric)
2012-03-06 16:55 UTC, jeanettedemarius
Details
image of plot saved and opened by 1.11.2 (141.13 KB, image/jpeg)
2012-03-06 17:25 UTC, Andreas J. Guelzow
Details

Description jeanettedemarius 2012-03-06 13:01:41 UTC
Created attachment 209082 [details]
formatted chart after saving the ods file (top) and after closing and reopen (bottom)

Some format options of a chart disappear when saving then closing and re-opening an .ods document (see attached files: before_closing.jpg and after_reopening.jpg).
The formatting features which disappear are (in this case) the values of the main and secondary graduations (on both X and Y axes), and the format of the axes scales.
Comment 1 Andreas J. Guelzow 2012-03-06 16:20:21 UTC
Would you be able provide the original Gnumeric file? This makes testing easier.

Which version of the ODF exporter are you using? With or without foreign elements?
If you save without foreign elements you will of course loose all formatting characteristics that are not supported natively in ODF. And that are a lot.
Comment 2 Andreas J. Guelzow 2012-03-06 16:26:03 UTC
I should have noted that the two images seem to be much more similar than I would have expected or hoped for.

Note that exporting to ODF should really only be used to transfer to another application, where you will always loose the properties not supported natively in ODF (ODF allows extensions aka "foreign elements" but a differnet application will not normally not be able to understand those extensions.)
Comment 3 jeanettedemarius 2012-03-06 16:39:29 UTC
(In reply to comment #1)
> Would you be able provide the original Gnumeric file? This makes testing
> easier.
> 
> Which version of the ODF exporter are you using? With or without foreign
> elements?
> If you save without foreign elements you will of course loose all formatting
> characteristics that are not supported natively in ODF. And that are a lot.

I saved the file (see 671461.ods) as ODF/Openoffice with foreign elements (*.ods). No idea of the version of the ODF exporter (gnumeric is 1.10.17).

I use this format to open/modify files using OpenOffice on a PC with windows XPPro...

Actually the compatibility is quite good, but when working on dozens of charts, this "bug" is ennoying...
Comment 4 jeanettedemarius 2012-03-06 16:42:03 UTC
Created attachment 209100 [details]
original see 671461.ods file
Comment 5 Andreas J. Guelzow 2012-03-06 16:44:06 UTC
When open the file in OpenOffice you will unfortunately always loose some
formatting (limitations of the ODF format). But of course possibly not as many
as you do currently.
Comment 6 Andreas J. Guelzow 2012-03-06 16:47:24 UTC
671461.ods is the saved file, showing the graph according to the "bottom image" in the jpg. Do you have a file (.gnumeric) showing the graph as in the top image?
Comment 7 jeanettedemarius 2012-03-06 16:55:43 UTC
Created attachment 209101 [details]
.gnumeric file

here is the .gnumeric file
Comment 8 Andreas J. Guelzow 2012-03-06 17:25:21 UTC
Created attachment 209104 [details]
image of plot saved and opened by 1.11.2

THe attached file shows plot after the file was saved as ods and opened using Gnumeric 1.11.2.

The differences I see are:

format of the x-tick-labels
color of the grid lines

Did I miss anything?

Note that the spacing of the major y-tick labels matches what I see when I open the gnumeric file. This is different from what is shown in your image.
Comment 9 jeanettedemarius 2012-03-06 17:36:38 UTC
(In reply to comment #8)
> Created an attachment (id=209104) [details]
> image of plot saved and opened by 1.11.2
> 
> The attached file shows plot after the file was saved as ods and opened using
> Gnumeric 1.11.2.
> 
> The differences I see are:
> 
> format of the x-tick-labels
> color of the grid lines
> 
> Did I miss anything?
> 
> Note that the spacing of the major y-tick labels matches what I see when I open
> the gnumeric file. This is different from what is shown in your image.

Actually you're right, I am presently working with this file and the version I attached had been modified after it was saved as .ods

Anyway, I think I will stop using OpenOffice for such tasks, .gnumeric format is much more ergonomic.
Thanks a lot for your assistance!
Comment 10 Andreas J. Guelzow 2012-03-06 18:06:35 UTC
By the way, thank you for submitting this bug report. There seem to be a bunch of issues with the export/import of some of the other graphs. This gives us nice examples to try to improve both Gnumeric's import/export to ODF and the ODF specification itself.
Comment 11 Andreas J. Guelzow 2012-03-12 06:05:50 UTC
We now import color and width of the grid lines.
Comment 12 Andreas J. Guelzow 2012-03-12 15:59:25 UTC
color and thickness of the grid lines is now fixed.

I still see:
incorrect formatting of the x-tick-labels and y-tick-labels
incorrect size for the data point dots
Comment 13 Andreas J. Guelzow 2012-03-22 04:36:38 UTC
size for the data point dots is now being imported and exported.

I still see:
incorrect formatting of the x-tick-labels and y-tick-labels
Comment 14 Andreas J. Guelzow 2012-03-25 06:41:44 UTC
The formatting of the x-tick-labels and y-tick-labels is fixed now.

If you find other problems in teh chart import/export please create individual bug reports for them.

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.