Apache OpenOffice (AOO) Bugzilla – Issue 106236
ODFF: functions should be saved in upper case
Last modified: 2013-01-29 21:52:59 UTC
According to the OpenFormula draft: Implementations should write function names in all upper case when saving to a document. OOo fails to do that for function names it doesn't know. I have attached a sample ODF file containing unknown function names. When OOo resaves this file it saves those unkown function names in lower case.
Created attachment 65566 [details] sample ODS file
The error is as described. You have to use the attached file with OOo3.1.1 because DEV300m62 cannot open it at all nor does Excel 2007. @aguelzow: Are you sure the file is valid?
@regina: Am I sure that the file is valid? I have no evidence that it isn't. It passes the validator at http://tools.odftoolkit.org/odfvalidator/. Do you know why DEV300m62 can't open it?
I can open it in m55 but not in DEV300m60. In my debug build of DEV300m60 I get the error: Error: Exception is thrown during stream wrapping! From File c:/DEV300m60debug/package/source/zippackage/ZipPackageStream.cxx at Line 451 @aguelzow: No I do not know, why OOo doesn't open it. I'm not qualified enough to investigate the error. But if I save a new file with just a number in a cell in Gnumeric 1.9.10 in either of the two ods formats, I get the same error when opening them in DEV300m60.
regina: the zip wrapping problem is due to a bug in the underlying library which was fixed last April. OpenOffice 3.2 opens these files fine though. (After complaining briefly)