GNOME Bugzilla – Bug 676535
failures in string import/export from/to ODS
Last modified: 2012-05-22 23:49:25 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.
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.
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.
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.
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.
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?).
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.)
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.