GNOME Bugzilla – Bug 595750
Unexpected elements in .ODS file
Last modified: 2009-09-22 08:07:30 UTC
Created attachment 143528 [details] the problem file Hi all, I tried to open an .ods file in Gnumeric Spreadsheet 1.9.12 and it gave a Pre_XML Check'!A1 : Unable to parse '$#REF!.$L$30:$L$31' because 'Invalid expression' supposed to be openoffice 2.4 and openoffice 3.0 compliant.
... table:expression="$#REF!.$L$30:$L$31" ... That's what the file says. Andreas, is that valid for ods?
THis is supposedly ODF 1.0. The ODF1-.0 stadard says that the table:expression attribute contains "an expression with a name, for example, a part of a formula". Since ODF1.0 does not specify which formula language would be used in teh absence of a namespace, that expression could be valid but of course there is absolutely no way to know what it means. Assuming that this is a range address, then it is valid if "#REF!" is the name of a table. In this case there is no table with such a name and so this is not a valid ODF1.0 range address. Assuming that it is indeed an OpenFormula formula doesn't change anything. So this is _not_ a valid ODF1.0 file. Please file this bug with the generator of this file.
THere are also lots of "Unexpected element"s. We should check all of them!
Hi all, Is the bug unconfirmed or is it verified ? I see one status on my mail and one status on the bug page hence confused. Anyways, this form has been taken from http://freedom-matters.in/ . From the author its supposed to work both with Ooo 2.4,3.0 and 3.1 http://lists.fosscom.in/pipermail/network-fosscom.in/2009-September/001405.html <quote> This has been tested with OOo version 2.4 and 3.0 and 3.1. </quote> Looking forward for feedback on the same. I have also contacted the author so he may also contribute if some info. is needed on the bug as well.
> Is the bug unconfirmed or is it verified The file is invalid according to the standard. OpenOffice might still read it but the program that created this file should be fixed. Metadata claims it was OpenOffice.org/2.4 Linux OpenOffice.org_project/680m17 Build-9310 You might want to file a bug against OpenOffice. (As a practical matter, you can probably ignore the warning. That expression does not appear to be used. Since you are dealing with a tax sheet, you had better verify that!) We keep the bug open only because Gnumeric is also issuing a pile of unrelated warnings.
This is fixed in gnumeric/libgsf.