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 614672 - Open Office .org 3.2.0 says file is corrupt saved from gnumeric to ODF
Open Office .org 3.2.0 says file is corrupt saved from gnumeric to ODF
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
1.10.x
Other Linux
: Normal normal
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on: 614968
Blocks:
 
 
Reported: 2010-04-02 16:30 UTC by webe3vt
Modified: 2010-04-07 17:20 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description webe3vt 2010-04-02 16:30:49 UTC
I saved a gnumeric spreadsheet as ODF.  When I open the .ods file in Openoffice.org 3.2.0, I get a popup message saying the file is corrupt and asking if I want to correct the file.  It tells me not to trust the file after it is fixed.  There are a lot of cells so I don't know if it is good or not.
Comment 1 Morten Welinder 2010-04-02 20:53:43 UTC
Please attach a sample ods file for which this happens.  (And the source
gnumeric file too, if you can.)
Comment 2 Andreas J. Guelzow 2010-04-05 18:50:21 UTC
Without the file there is no way for us to determine whether this is a bug in Gnumeric or in Openoffice.org.
Comment 3 Andreas J. Guelzow 2010-04-05 18:54:38 UTC
Note that if this file is confidential, you could also send it to one of the developers directly and we would destroy it after having determined the problem.

If that is not possible you could perhaps run it throughthe validator at http://opendocumentfellowship.com/validator and show us the output.
Comment 4 webe3vt 2010-04-05 19:35:13 UTC
I have sent the files to jody and terra at gnome.org as the FAQ states for confidential files.
Comment 5 Morten Welinder 2010-04-05 19:43:29 UTC
Got it.
Comment 6 Andreas J. Guelzow 2010-04-06 02:40:45 UTC
This appears unrelated to the file mentioned above.

Yo get this error message from OOo3.2 with virtually every ods file created with a current version of gnumeric. These files validate as valid ODF with 
http://opendocumentfellowship.com/validator

The most reasonable explanation is that this is an OpenOffice bug!
Comment 7 Andreas J. Guelzow 2010-04-06 02:51:15 UTC
It is interesting to note that ODS files created by OpenOffice 3.2 do not validate!
Comment 8 Andreas J. Guelzow 2010-04-06 03:10:33 UTC
I have filed a corresponding bug report against OOo:
 http://www.openoffice.org/issues/show_bug.cgi?id=110633
Comment 9 Andreas J. Guelzow 2010-04-06 14:45:02 UTC
Okay according to the action on the OOo bug report:

1) The attached document is no valid ODF-document, it is even no valid Zip-package.
The problem is that general purpose bit flag of at least "mediatype" stream has
different values in Central Directory and in the local header. This is treated
as a sign of corruption by OOo.

2) The manifest.xml has an manifest:file-entry for a (non-existent) "Pictures/"

3) The usage of attribute style:writing-mode as an table cell attribute is not
valid regarding ODF 1.1
Comment 10 Morten Welinder 2010-04-06 15:19:47 UTC
Problem 1 filed as bug 614968.
Comment 11 Andreas J. Guelzow 2010-04-06 16:14:00 UTC
Problem (3) is not a problem. ODF 1.1 (15.8 & 15.8.13) allows style:writing-mode as a table-cell-properties. It does not appear as a table cell attribute.
Comment 12 Andreas J. Guelzow 2010-04-06 19:48:00 UTC
Problem (1) isn't really a problem. There is nothing in ODF prohibiting us to write that unnecessary manifest entry. Since it is unneeded though we shouldn't write it though.

THis has been fixed in trunk.
Comment 13 Andreas J. Guelzow 2010-04-06 19:49:18 UTC
I should have said "Problem (2)" in comment #12.

So everything appears to be fixed now (assuming a new libgsf).


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.
Comment 14 Andreas J. Guelzow 2010-04-07 15:41:13 UTC
Problem (3) is in fact (still) a problem. ODF 1.1 (15.8 & 15.8.13) allows
style:writing-mode as a style:table-properties attribute not as a style:table-cell-properties attribute.
Comment 15 Andreas J. Guelzow 2010-04-07 17:20:21 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.