[Libreoffice-bugs] [Bug 127587] hlookup and match fail for values outside defined range if range contains empty columns

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

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

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
This is not a bug. Specifying a 4th argument of 1 (i.e. not 0) the lookup range
MUST be sorted ascending, which with an empty cell between it is not. Range
lookup results on not strictly sorted data are arbitrary.

-- 
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/20200504/38d14edd/attachment-0001.htm>