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
The Help is correct. The error is in the Function Wizard. Patch https://gerrit.libreoffice.org/c/core/+/136499
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e4a57dcdabc9ae7d381025e008b90635c1b7b10c tdf#137747 Fix POISSON.DIST required argument It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Olivier Hallot committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/6ea86593851c731e2e2b969e458255e4159c80d9 tdf#137747 Fix POISSON.DIST required argument It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.