<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - PERCENTRANK produces Err:538 when over 100,000 rows of data referenced"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122411">122411</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PERCENTRANK produces Err:538 when over 100,000 rows of data referenced
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.1.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>pnetmod@f2s.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>