[Libreoffice-bugs] [Bug 137747] New: Calc Function Wizard - arguments not correctly described for POISSON.DIST function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137747

            Bug ID: 137747
           Summary: Calc Function Wizard - arguments not correctly
                    described for POISSON.DIST function
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stevemfanning.wh at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201025/8d791f98/attachment.htm>