https://bugs.documentfoundation.org/show_bug.cgi?id=122411
Bug ID: 122411
Summary: PERCENTRANK produces Err:538 when over 100,000 rows of
data referenced
Product: LibreOffice
Version: 6.0.1.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
As per title:
Using 64bit Windows version 6.0.1.1, =PERCENTRANK(A1:a100001,0.5,) e.g. in cell
D1, with column A1:A100001 filled with random numbers between 0 and 1 produces
Err:538 (not even listed in my version of Help!)
Reduce the number of rows below 100,000 and the calculation is correct.
Contrast with PERCENTILE(), which happily deals with at least 320,000 rows.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
