https://bugs.documentfoundation.org/show_bug.cgi?id=132131
--- Comment #28 from Julien Nabet <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
