Description: WRT ODFF1.2 constraint 'If (x + r - 1) <= 0 NEGBINOMDIST returns an Error.' is not applied. NEGBINOMDIST is not compliant with Excel (https://support.office.com/en-us/article/NEGBINOMDIST-function-f59b0a37-bae2-408d-b115-a315609ba714), although neither is Excel itself WRT non numeric arguments. Steps to Reproduce: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Also, Calc does not convert arguments x and r to integers, which it should.
Created attachment 129527 [details] test document used
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=245b615400904274e264d5051baf63b3613db935 tdf#104581 handle constraints for NEGBINOMDIST in compliance with ODFF1.2. It will be available in 5.4.0. 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.
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=83675eeb30c92a17dd272894df34b89628de0142&h=libreoffice-5-3 tdf#104581 handle constraints for NEGBINOMDIST in compliance with ODFF1.2. 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.