Bug 137747 - Calc Function Wizard - arguments not correctly described for POISSON.DIST function
Summary: Calc Function Wizard - arguments not correctly described for POISSON.DIST fun...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
 
Reported: 2020-10-25 20:11 UTC by Steve Fanning
Modified: 2020-10-26 12:53 UTC (History)
0 users

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 Steve Fanning 2020-10-25 20:11:45 UTC
Description:
Calc's POISSON.DIST function appears to require three arguments - Number, Mean, and C. This makes sense because the whole purpose of the function's existence is for interoperability with the correspondingly named function in Excel (for which the three arguments are required).

However the text in Calc's Function Wizard states that the third argument (Cumulative, used to select between the probability distribution function and the cumulative distribution function) is optional.

Experimentation (see below) seems to indicate that the Cumulative argument is indeed required, meaning that the Function Wizard's text is misleading.

The associated help page contains the same apparent error.

Steps to Reproduce:
1. Open Function Wizard and navigate to POISSON.DIST function.
2. Click in box adjacent to Cumulative argument and note that description states that this argument is optional.
3. Close Function Wizard.
4. Pick an empty spreadsheet cell and enter the formula =POISSON.DIST(60;50;1). Note that the cell contains a valid value (0.927 etc) and no error is displayed.
4. Pick another empty spreadsheet cell and enter the formula =POISSON.DIST(60;50). Note that this cell contains the error message Err:511 and the status line contains the text "Error: Variable missing".



Actual Results:
See above

Expected Results:
See above


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 6; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded