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 676535 - failures in string import/export from/to ODS
failures in string import/export from/to ODS
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: 2012-05-22 01:12 UTC by Andreas J. Guelzow
Modified: 2012-05-22 23:49 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Andreas J. Guelzow 2012-05-22 01:12:22 UTC
Open the sample file formats.xls.
Save that file as an ODF file with foreign elements.
quit
Reopen both files.
The xls files shows 5 failures but the ODF file shows 45 failures. So at least 40 formats did not correctly survive the roundtrip.
Comment 1 Andreas J. Guelzow 2012-05-22 04:58:56 UTC
At least some of these extra failures are not formatting related, for example cell Conditions!D52 contains a string to compare with a formatted string. in the ODS file this is empty so istext is false while in the xls file it contains the empty string (') so istext is true. The formatting yields teh empty string both times, so this is flagged as incorrect in the ODS file.
Comment 2 Andreas J. Guelzow 2012-05-22 05:32:03 UTC
None of these failures has anything to do with formatting. These are all issues with string storage, eg. the above empty string issue, an occasional missing space at the end of a string etc.
Comment 3 Andreas J. Guelzow 2012-05-22 06:58:54 UTC
The empty string issue is fixed as well as the fact that 2 consecutive spaces were transformed into a single space has been fixed (3 or more consecutive spaces were handled fine.)

This has dropped the failures to 23, still 18 more than the xls file shows.
Comment 4 Andreas J. Guelzow 2012-05-22 07:06:26 UTC
hmm, the empty string issue is still there, but I can't even figure out how to create the situation obtained through xls import inside Gnumeric proper, ie. to obtain a string cell where when editing starts there is only a "'" in the edit box.
Comment 5 Andreas J. Guelzow 2012-05-22 14:04:53 UTC
The empty string issue is fixed now, but there is still a problem with Conditions!C52. When the created ODF file is opened the formula in Conditions!C52 seems to be missing (now?).
Comment 6 Andreas J. Guelzow 2012-05-22 22:01:58 UTC
If I take the formats.xls file, delete all sheets but the Conditions sheet, save as an xls file, then as an ods file, the formula in Conditions!C52 is correctly saved. 

If I save the original formats.xls file as an ods, file the formula in Conditions!C52 is omitted. (At least LO doesn't see it either.)
Comment 7 Andreas J. Guelzow 2012-05-22 23:49:25 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.