Issue 110229 - ODFF: add BINOM.DIST.RANGE as an alias for B
Summary: ODFF: add BINOM.DIST.RANGE as an alias for B
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sc
URL: http://www.oasis-open.org/committees/...
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-18 18:53 UTC by ooo
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

Attachments
B, TDIST and macro function FOO; loads in all versions (9.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-08 12:50 UTC, ooo 		no flags Details
BINOM.DIST.RANGE, LEGACY.TDIST and macro function USER.FOO; loads only in this and later versions (9.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-08 12:51 UTC, ooo 		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 ooo 2010-03-18 18:53:03 UTC 
The OpenFormula draft changes B() to BINOM.DIST.RANGE()
Add BINOM.DIST.RANGE as an alias for B so documents of future releases can be
read in this release. Do not write BINOM.DIST.RANGE in this release.
Comment 1 ooo 2010-06-07 17:45:20 UTC 
The same for TDIST -> LEGACY.TDIST
Comment 2 Regina Henschel 2010-06-07 19:18:01 UTC 
And what about the other LEGACY functions?
Comment 3 ooo 2010-06-07 20:53:53 UTC 
@regina: other LEGACY.* are already mapped. These functions here were renamed in
the drafts after we started to we write in the OpenFormula namespace.
Comment 4 ooo 2010-06-07 20:55:25 UTC 
ODFF recommends to store user-defined functions prefixed with "USER.", so in
macro function name check also try "XXX" for "USER.XXX".
Comment 5 ooo 2010-06-07 22:32:33 UTC 
In cws calc55:

changeset d6c0363308e0
http://hg.services.openoffice.org/cws/calc55/changeset/d6c0363308e0
M sc/source/core/tool/compiler.cxx

You can observe the progress and possible integration date of CWS calc55 at
http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalc55
Comment 6 ooo 2010-06-08 12:50:19 UTC 
Created attachment 69867 [details]
B, TDIST and macro function FOO; loads in all versions
Comment 7 ooo 2010-06-08 12:51:57 UTC 
Created attachment 69868 [details]
BINOM.DIST.RANGE, LEGACY.TDIST and macro function USER.FOO; loads only in this and later versions
Comment 8 ooo 2010-06-08 12:57:29 UTC 
Reassigning to QA for verification.
Comment 9 ooo 2010-06-08 14:15:15 UTC 
To 'kla'.
Comment 10 kla 2010-06-16 09:46:07 UTC 
Seen ok in cws calc55 -> verified
Comment 11 kla 2011-04-01 12:01:27 UTC 
Seen ok into the master -> closed