Bug 137747

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