Bug 67205 - CRITBINOM function description is wrong
Summary: CRITBINOM function description is wrong
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
4.1.0.2 rc
Hardware: All All
: medium normal
Assignee: Eike Rathke
URL:
Whiteboard: target:4.3.0 target:4.2.0.1
Keywords:
Depends on:
Blocks:
 
Reported: 2013-07-23 05:58 UTC by Mikeyy - L10n HR
Modified: 2013-12-12 17:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mikeyy - L10n HR 2013-07-23 05:58:12 UTC
Reported by Sergio, smarquespt@gmail.com
This affects HELP and UI in EN_US

Dana 22.7.2013. 23:11, Sérgio Marques je napisao:
>
>
> 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 value.</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
Comment 1 Joel Madero 2013-07-23 16:32:33 UTC
In the future please don't include emails like this :) Bugs should be reported:

Reproducible Steps:
1.
2.
3.
etc..


Expected: 

Observed:


Relevant links:
(link to email thread perhaps :) )

OS -
LibreOffice Versions:

Or some variation of the above :) Much easier to follow. Thanks for the report
Comment 2 Mikeyy - L10n HR 2013-07-23 20:21:25 UTC
Oh well. :)
In short, description of that function in HELP is wrong and it should be corrected.
Author also suggested that UI description for LO should be more informative. Current UI description isn't wrong (probably, didn't check), but it's short and not informative.

He suggested that they be replaced with Oasis description:
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
Comment 3 Commit Notification 2013-12-12 17:36:15 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=392217fbe5d2432d2834e4593457cb2d236b99dd

resolved fdo#67205 CRITBINOM "greater than or equal"



The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 4 Commit Notification 2013-12-12 17:39:40 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-4-2":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=ced1a84353e7bc399b078b55b2f911dabcce9ba2&h=libreoffice-4-2

resolved fdo#67205 CRITBINOM "greater than or equal"


It will be available in LibreOffice 4.2.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 5 Commit Notification 2013-12-12 17:57:28 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=0c447b5d32b5d65960e61969d1a0ead4f4dbe7c0

resolved fdo#67205 CRITBINOM and BINOM.INV, use ODF OpenFormula description



The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 6 Commit Notification 2013-12-12 17:58:47 UTC
Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-4-2":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=45bd5635730f6faa6d1d9d82c00e63b487bf141d&h=libreoffice-4-2

resolved fdo#67205 CRITBINOM and BINOM.INV, use ODF OpenFormula description


It will be available in LibreOffice 4.2.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.