https://bugs.documentfoundation.org/show_bug.cgi?id=150099
Bug ID: 150099
Summary: HYPGEOM.DIST function is not working properly
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: vojta...@gmail.com
Description:
The HYPGEOM.DIST function does not work in some cases and returns zero instead
of the true value (which can be correctly calculated with the same function in
MS Excel or phyper in R).
Steps to Reproduce:
enter formula: =HYPGEOM.DIST(2132;3533;5491;8658;1)
Expected Results:
4,70E-07
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Slightly altering the numbers mentioned above still results in incorrect (0)
result, on the other hand =HYPGEOM.DIST(1;13;5;52;1) returns 0,632953181272509
in both Calc and MS Excel (which is the correct result).
I tried this on two different computers - one with windows (and LibreOffice
7.2.7.2) the other was running linux (and LibreOffice 7.3.4.2).
--
You are receiving this mail because:
You are the assignee for the bug.
