Issue 126519 - Some wrong function names written to ODS (according to OpenFormula spec)
Summary: Some wrong function names written to ODS (according to OpenFormula spec)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.1.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-14 17:30 UTC by Daniel Rentz
Modified: 2024-02-16 00:20 UTC (History)
2 users (show)

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

Attachments
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 Daniel Rentz 2015-09-14 17:30:44 UTC 
1) The UI function "B" is specified by OpenFormula as "BINOM.DIST.RANGE" (http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#BINOM_DIST_RANGE) but AOO writes it as "B" into the XML.

2) The UI function "EASTERSUNDAY" is not specified by OpenFormula. LibreOffice writes it as "ORG.OPENOFFICE.EASTERSUNDAY", so should AOO.

3) The most serious one: The UI function "RRI" is spec'ed as such by OpenFormula (http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#RRI) but AOO writes it as "ZGZ" to the ODS file which is the German translation of "RRI".

4) The UI function "TDIST" is spec'ed as "LEGACY.TDIST" (http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#LEGACY_TDIST) but AOO writes it as "TDIST".
Comment 1 Regina Henschel 2015-09-14 20:04:04 UTC 
You are right for all four items.
Do you want to fix it?
Comment 2 Daniel Rentz 2015-09-15 20:55:11 UTC 
FYI: related https://bugs.documentfoundation.org/show_bug.cgi?id=94214

@rh: Uhm did not do any OpenOffice related dev for a long time now :) Nobody else here actively developing for AOO?

In this case, it's not just changing the function names in the code, but for sake of backwards compatibility, the old "wrong" function names still need to be supported in the import filter.
Comment 3 Regina Henschel 2015-09-15 21:19:40 UTC 
Hi Daniel, we would be very happy, if such a well known, experienced developer of OpenOffice as you, decides to develop for Apache OpenOffice. When you will look at the commits you will notice, that there are only very few developers working on the core since IBM decides to significantly reduce its commitment. Your help is highly welcomed.
Comment 4 Daniel Rentz 2015-09-17 08:54:06 UTC 
See also issue 106210