Issue 106236 - ODFF: functions should be saved in upper case
Summary: ODFF: functions should be saved in upper case
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.0.1
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-10-24 06:00 UTC by aguelzow
Modified: 2013-01-29 21:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample ODS file (6.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-24 06:01 UTC, aguelzow
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description aguelzow 2009-10-24 06:00:15 UTC
According to the OpenFormula draft:
Implementations should write function names in all upper case when saving to a

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.
Comment 1 aguelzow 2009-10-24 06:01:23 UTC
Created attachment 65566 [details]
sample ODS file
Comment 2 Regina Henschel 2009-10-24 13:26:42 UTC
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?
Comment 3 aguelzow 2009-10-24 17:07:29 UTC
@regina: Am I sure that the file is valid? I have no evidence that it isn't. It
passes the validator at Do you know
why DEV300m62 can't open it?
Comment 4 Regina Henschel 2009-10-24 18:48:22 UTC
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.
Comment 5 aguelzow 2010-06-17 17:28:21 UTC
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)