[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

--- Comment #28 from Julien Nabet <serval2412 at yahoo.fr> ---
No bug here, it's described in
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
"
If the Sorted parameter is omitted or set to TRUE or one, it is assumed that
the data is sorted in ascending order. In this case, if the exact
SearchCriterion is not found, the last value that is smaller than the criterion
will be returned.
"
So in your case, sort your data on G column (since it's the key search), then
put 0 for last argument.

For the rest, indeed it's different from Excel since the last argument hasn't
the same meaning.

-- 
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/3cf3635a/attachment.htm>