[Libreoffice-bugs] [Bug 105120] RANK.EQ function compatibility with excel2016 online

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=105120

Winfried Donkers <winfrieddonkers at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
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.

-- 
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/20171108/c6c9db59/attachment.html>