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 660657 - Gnumeric should open Google-docs created so-called ODS files
Gnumeric should open Google-docs created so-called ODS files
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export OOo / OASIS
git master
Other Linux
: Normal enhancement
: ---
Assigned To: Andreas J. Guelzow
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-10-01 22:21 UTC by Andreas J. Guelzow
Modified: 2011-10-01 23:46 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample ODS file (3.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-01 22:21 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2011-10-01 22:21:28 UTC 
Created attachment 197986 [details]
sample ODS file

ODS files generated bu google-docs are not valid. For example running the attached file through an ODF validator causes:

upload:///GD-spread.ods[-1,-1]:Error:The 'mimetype' file have to be contained in the ODF XML Schema package 'upload:///GD-spread.ods'!
upload:///GD-spread.ods/styles.xml[1,2133]:Error:element "style:table-cell-properties" was found where no element may occur
upload:///GD-spread.ods/styles.xml[1,2443]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,2696]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,2950]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,3474]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,3727]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,3981]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,4505]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,4757]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,5010]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,5533]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,5785]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,6038]:Error:unexpected attribute "number:volatile"
upload:///GD-spread.ods/styles.xml[1,7113]:Error:tag name "style:table-cell-properties" is not allowed. Possible tag names are: <map>
upload:///GD-spread.ods/styles.xml[1,7453]:Error:attribute "style:name" has a bad value: "Currency[0]" does not satisfy the "NCName" type
upload:///GD-spread.ods/styles.xml[1,7656]:Error:attribute "style:name" has a bad value: "Comma[0]" does not satisfy the "NCName" type
upload:///GD-spread.ods:Info:Generator: null

So it is not surprising that we fail to open it with "Unknown File Type".

If the user specifically selects the ODF file we encounter unexpected elements, which might be our fault or they may simply be invalid where they appear.

Nevertheless we should be able to make sense out of that file!
Comment 1 Andreas J. Guelzow 2011-10-01 22:54:17 UTC 
When the user specifies this to be a ODF (ODS) file then we guess it to be an old style openoffice file since the mimetype is missing. As a consequence we fail to interpret this as well as we could.
Comment 2 Andreas J. Guelzow 2011-10-01 23:46:27 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.