[Libreoffice-bugs] [Bug 122411] New: PERCENTRANK produces Err:538 when over 100, 000 rows of data referenced

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: pnetmod at f2s.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190101/24977859/attachment-0001.html>