https://bugs.documentfoundation.org/show_bug.cgi?id=105019
Bug ID: 105019
Summary: POISSON and POISSON.DIST functions
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r...@post.cz
Description:
POISSON spec
*Syntax:* POISSON( /Integer/ x ; /Number/ l [ ; /Logical/ Cumulative =
TRUE() ] )
*Returns:* Number
*Constraints:* l > 0, x >= 0
Constraint for l is not applied correctly.
POISSON and POISSON.DIST are identical as far as the function code is
concerned.
When POISSON.DIST is saved, or when POISSON is saved to xls/xlsx, it should be
saved with 3 arguments (adding the cumulative argument if not entered in Calc)
to achieve interoperability.
Syntax
POISSON.DIST(x,mean,cumulative)
Cumulative Required.
But in Calc formula =POISSON.DIST(150,120) works. Should not work, because
third parameter is not present.
Actual Results:
.
Expected Results:
.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs