When the "Cumulated" parameter set to TRUE, HYPGEOM.DIST function returns the cumulative value. The function wizard says the contrary: > Cumulated. TRUE calculates the probability mass function, FALSE the cumulative distribution function.
Winfried: one for you?
(In reply to comment #1) > Winfried: one for you? I confirm behaviour, will fix asap with request to put it in version 4.2.
Fix submitted: https://gerrit.libreoffice.org/#/c/7227/
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0282ab3c3aa89938d944e8823d0ae4cd0cdeaaf2 fdo#73117 fix switched true/false explanation for HYPGEOM.DIST 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-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1142320ccd6e9d7dcfcda339cd2b32674b7a3d32&h=libreoffice-4-2 fdo#73117 fix switched true/false explanation for HYPGEOM.DIST It will be available in LibreOffice 4.2. 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: following your patches for master and 4.2 branches, we can consider this one as fixed.
(In reply to comment #6) > Winfried: following your patches for master and 4.2 branches, we can > consider this one as fixed. Julien: You're right of course. I forgot to set the status to fixed. Thank you :)