[Libreoffice-bugs] [Bug 121090] Help of vlookup and hlookup: Sort order or Order are Approximate

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
Thanks for filing the report!

(In reply to gmolleda from comment #0)
> In help of functions vlookup and hlookup there is an error: the fourth
> parameter must be "Approximate" and not "Order sort" nor "Sorted".

Please describe why do you think it's so? The fourth parameter actually is a
boolean, which positive (true) value really tells the functions that the Array
(2nd argument) is sorted. This makes the functions use an algorithm based on
that assumption, thus not giving a correct answer when the Array isn't really
sorted. The "approximate" seems to be orthogonal to that.

Setting to NEEDINFO. Please reset back to NEW when provided the requested
clarifications. Thanks!

-- 
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/20181101/f34efb27/attachment.html>