[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

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to gmolleda from comment #5)
> The fourth parameter, what is it for?
> Do you inform the function about whether the list is ordered? 
> or 
> Ask the function to do an approximate search or not?

The reason for choosing the value for 4th parameter may vary; and that you
chose one of possible reasons is just a use case. Another valid use case is
speed.

Furthermore, the wording in LO is chosen not to follow the standard wording
(which is more strictly correct, being "RangeLookup"), for purpose: the option
*requires* that the argument 2 is sorted, (something that is not apparent from
"range lookup" name) - and failing that requirement *is the most common error
among users*, even with the "sorted" put into the argument name in help, and in
function wizard (as we have now)! Naming it otherwise would do more harm to
users (especially not power users) than "good" to purists who understand their
reasons to use the option in any case.

> Could be that I do not understand the English, because I am spanish and so
> the Esperanto language is better for international communications.

I am Russian, so using Esperanto would not work for me. And please refrain from
irrelevant, argumentative, and politicized topics in the bug tracker.

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