GNOME Bugzilla – Bug 641581
sc/xspread import produces errors
Last modified: 2011-02-05 16:22:23 UTC
I'm trying to use the newly-updated-in-1.10.12 SC/XSpread importer to convert a large, complicated SC spreadsheet to a more widely supported format. The conversion produces a large number of errors on stderr, but appears to succeed (I'd have to do a cell-by-cell comparison to tell if it worked completely as it should). I'll attach a version of the spreadsheet I'm trying to convert (with all significant data replaced) and the standard output and standard error from running ssconvert.
Created attachment 180151 [details] The spreadsheet that produces these errors on import I produced this from the spreadsheet I care about by replacing all text cells with their cell location as text and each numeric (non-formula) cell with a unique number. It's compressed, as it's 1.4 megs before compression.
Created attachment 180152 [details] Errors printed to standard error These are the errors printed to standard error when I run ssconvert on that SC file. Standard output only tells me "Using exporter Gnumeric_XmlIO:sax".
Created attachment 180153 [details] Errors shown when I use the UI to import These errors are shown in a dialog box when I just open the SC file using Gnumeric, in addition to the other errors being printed to stderr. These may help point out which cells are giving trouble.
Following up on those extra errors suggests that it's failing to deal properly with text references to later in the spreasheet, or perhaps even text references in general.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.