Description: 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: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: Additional Info: 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.
https://github.com/libreoffice/core/commit/ccbb0dd8788bf481f398782bf1519cd57c3b2bfb
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5c20348e66b6c8fe88d204ba5b6f01b572334152&h=libreoffice-5-3 tdf#104532 handle constraints for NEGBINOM.DIST correctly. It will be available in 5.3.0.1. 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.