Issue 106236 - ODFF: functions should be saved in upper case
Summary: ODFF: functions should be saved in upper case
Status: CONFIRMED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
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: ---

Attachments
sample ODS file (6.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-24 06:01 UTC, aguelzow 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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
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.
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 http://tools.odftoolkit.org/odfvalidator/. 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)