GNOME Bugzilla – Bug 536552
Opening ODS file gives "Invalid integer"
Last modified: 2008-06-28 18:38:55 UTC
Please describe the problem: I opened a file produced by scalc and received the cryptic error message 'Power Bills'!E6 : Invalid integer '2', for 'number-columns-repeated' 'Power Bills' is a valid sheet in the file, but its cell E6 is empty. I am puzzled whether I can trust the import. Using scalc I removed all other sheets and all data below row number 6. Then I saved it as a different file. When opening in Gnumeric I still get the error. If I save the file in Gnumeric I do not get the error on subsequent openings. Steps to reproduce: Actual results: Expected results: I would expect being told what caused the problem in a way I understand. Does this happen every time? The problem happens so far only with this one file (unfortunately I cannot see any upload option) Other information:
Created attachment 112107 [details] SCALC file; one sheet, a few formulas; last cell: L6 The file causing the problem.
I just get three messages in the console: Unexpected element 'draw:marker' in state : {catch all)} -> styles Unexpected element 'office:annotation' in state : document-content -> body -> spreadsheet -> table -> table-row ->table-cell Unexpected element 'office:annotation' in state : document-content -> body -> spreadsheet -> table -> table-row ->table-cell
Terribly sorry that I forgot to mention that I'm still on Windows. (I will switch one day, but first I have to familiarize myself with all necessary software; luckily Gnumeric is cross platform :-) I don't understand the details of the errors you got, but apparently there is something fishy in that file. But as the imported file looked fine (at least on the surface) I rated it only "trivial". I just noticed that the export as *.ods from Gnumeric is marked as "_UNFINISHED_"; so maybe the import isn't finished either and I should check again later?
The messages I get are most probably related to not yet supported features, either in gnumeric or in the importer. The exporter is unfinished, and unfortunately, it seems that there is no much activity in this area at the moment.
Currently ODF/ODS does not yet define the meaning of any functions. It will likely use OpenFormula in the future, but even OpenFormula is still in flux. So there really isn't yet a standard useful Open Document Format for spreadsheets.
Ahh, I see the problem. We use strtol, and check errno, but never reset it to 0. If something had set it previously we get a false failure.