The argument constraints
-Number_f and number_s are truncated to integers
-If number_f < 0 or number_s < 1, NEGBINOM.DIST returns the #NUM! error value
are not handled correctly.
Steps to Reproduce:
User Profile Reset:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Created attachment 129429 [details]
test document used
Rows 22, 27 and 28 produce incorrect results.
Winfried Donkers committed a patch related to this issue.
It has been pushed to "libreoffice-5-3":
tdf#104532 handle constraints for NEGBINOM.DIST correctly.
It will be available in 22.214.171.124.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.