Bug 137259 - Misleading Help descriptions for the BETAINV and BETA.INV functions of Calc
Summary: Misleading Help descriptions for the BETAINV and BETA.INV functions of Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: target:7.4.0
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2020-10-05 08:40 UTC by Steve Fanning
Modified: 2022-03-09 17:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Steve Fanning 2020-10-05 08:40:40 UTC
The description of the first argument to these functions reads "Number is the value between Start and End at which to evaluate the function". This appears to be incorrect - the Start and End values are intended to constrain the results of the functions, not the input probability.

Suggest clarify that Number is the probability associated with the BETA
distribution for other given arguments (Alpha and Beta). Also suggest updating the descriptions of the Start and End arguments to reflect that they define a range for the output of the function.

Finally it may be worth adding a comment about the defaults applied when Start and End are not specified.

Steps to Reproduce:
1. View relevant Help page

Actual Results:

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Rafael Lima 2022-01-10 19:49:46 UTC
Indeed, the Number parameter is actually the cumulative probability for which the X value is to be found.

If Start and End are note defined, then default values are 0 and 1, respectively (see [1]).

[1] https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr3.cxx?r=37429f26#2213
Comment 2 Commit Notification 2022-02-12 20:02:07 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":


tdf#137259 Update BETAINV and BETA.INV description