<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - RANK.EQ function compatibility with excel2016 online"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105120">bug 105120</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - RANK.EQ function compatibility with excel2016 online"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105120#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - RANK.EQ function compatibility with excel2016 online"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=105120">bug 105120</a>
from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a>
</span></b>
<pre>Cells A2 and A15 contains arguments (inline array, multiple reference) that
cannot be handled by Excel Online.
Cells A10 and A12 give seemingly different results in Excel because the times
in the array M3:M9 are calculated and not exactly identical. Adding ROUNDSIG to
the time calculation (e.g. =ROUNDSIG(L3-K3; 10)) solves that.</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>