[Libreoffice-bugs] [Bug 132131] Error with new function recherchev (in french)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #36 from Eike Rathke <erack at redhat.com> ---
Nothing to fix or implement here. If you tell VLOOKUP() to do a range lookup by
not giving the 4th parameter at all then the lookup range MUST be sorted,
otherwise the result will be *arbitrary*. This is the same in Calc and Excel
though the result may be different arbitrary due to different search algorithms
and *by accident* may be what is expected in one or the other. See also
https://help.libreoffice.org/6.4/en-GB/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152

-- 
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/20200420/28b68dfd/attachment.htm>