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 725258 - Sheet formatting round trip issues
Sheet formatting round trip issues
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other All
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2014-02-26 18:43 UTC by Morten Welinder
Modified: 2014-02-28 07:39 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Morten Welinder 2014-02-26 18:43:33 UTC 
New t6508:

-    <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="1" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
+    <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">

...

-    <gnm:Sheet DisplayFormulas="1" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
+    <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
Comment 1 Morten Welinder 2014-02-27 03:30:52 UTC 
When localc loads the xls generated from our file, I don't see any of
the tests working other than the "hide-the-grid" and RTL.  So LO
probably doesn't have setting for these.

And since ods==whatever-oo-generated, odds are good that ods cannot store
these.
Comment 2 Andreas J. Guelzow 2014-02-27 07:04:19 UTC 
There is no standard way to store "hide-the-grid" in ODF. LO uses here the settings mechanism provided by ODF that can store arbitrary settings.

Similarly we can use either the settings mechanism or foreign elements to store any settings we want. Personally I prefer foreign elements or attributes, but if LO has defined some settings we should probably use them.
Comment 3 Andreas J. Guelzow 2014-02-28 07:38:19 UTC 
The round trip issue is fixed but if I save an other wise empty and default file with no row headers as ODF and reopen the file, I get a frozen single row pane.
Comment 4 Andreas J. Guelzow 2014-02-28 07:39:52 UTC 
The frozen single pane also appear for files saved as .gnumeric. So that is not an ODF issue.

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.