CRITBINOM function description is wrong

l10n
#1

File: scalc/01.po
Context: 04060183.xhp par_id3149254 49 help.txt
Comments: yXdFy

<ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the
cumulative binomial distribution is less than or equal to a criterion value.
</ahelp>

Should be:

<ahelp hid="HID_FUNC_CRITBINOM">Returns the smallest value for which the
cumulative binomial distribution is greater than or equal to a criterion
value.</ahelp>

Also in:

File:

sc/source/ui/src.po
Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text
Comments:

o6CUv

Should be:

Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text

#2

Nice catch.
Oasis says it's "greater then"
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM

MS Office says "less then" in function title description
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1

and then it says "greater then" in function description
http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955

LO says "less then".
Would be nice if someone could actually use this formula and say which is true. :slight_smile:

Best regards,
Mihovil

Dana 22.7.2013. 1:44, Sérgio Marques je napisao:

#3

Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he can fix it?

Best regards,
Mihovil

Dana 22.7.2013. 17:21, Brian Barker je napisao:

It hardly necessary to do any testing: cumulative probability distributions start at zero and finish at one. Zero is always going to be less than any criterion value, so any result is going to correspond to the start of the distribution and be trivial. The original correspondent must be right: "greater than" is surely correct?

Brian Barker

Dana 22.7.2013. 18:08, Regina Henschel je napisao:

#4

Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he can fix it?

I don´t have an bugzilla account. Can You do it? Or someone with an account
there.

What needs to be fixed is:

UI:

File: sc/source/ui/src.po
Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text

     Comment:

o6CUv

Border arguments of the binomial distribution.

To:
Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text
Returns the smallest value for which the cumulative binomial distribution
is greater than or equal to a criterion value.

Help files:
File:

scalc/01.po
Context:

04060183.xhp par_id3149254 49 help.text
Comment:

yXdFy

From:

<ahelp hid="HID_FUNC_KRITBINOM">Returns the smallest value for which the
cumulative binomialdistribution is less than or equal to a criterion value.
</ahelp>

To

<ahelp hid="HID_FUNC_CRITBINOM">Returns the smallest value for which the
cumulative binomialdistribution is greater than or equal to a criterion va
lue.</ahelp>

If someone could do it I would appreciate it.

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM

Regards

#5

Done.
https://bugs.freedesktop.org/show_bug.cgi?id=67205

Dana 22.7.2013. 23:11, Sérgio Marques je napisao: