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).
repro in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 8580cbdc19224bc2a467535cc527cd28b0f30879 CPU threads: 4; OS: Mac OS X 12.5; UI render: Skia/Metal; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded
This function was added in bug 71722 and return 0,000000469978167 in excel 2010
repro in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d8e6b488ceaff7c88856ebcfcfec14d2d8cd7652 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded also in Version: 7.4.4.2 (x64) / LibreOffice Community Build ID: 85569322deea74ec9134968a29af2df5663baa21 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL XLSX file (created in LO) with both formulas, in Excel show the non-zero value(s).