https://bugs.documentfoundation.org/show_bug.cgi?id=168064
Bug ID: 168064
Summary: Misleading help for MATCH
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The help for MATCH at
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407
is misleading. I see that this problem was raised with Bug ID 144770, and
supposedly the help was modified to correct it, but actually the help (at the
URL I give above) still says what it said back when the other person
complained!
The help says:
"If Type = 1 or the third parameter is missing, the index of the last value
that is smaller or equal to the search criterion is returned. This applies even
when the search array is not sorted."
But it should say something like:
"If Type = 1 or the third parameter is missing, the index is returned of the
last value encountered smaller or equal to the search criterion before
encountering a value larger than the search criterion while going through the
array. If you want the index of the highest value smaller or equal to the
search criterion then the search array must sorted in ascending order."
That's rather complicated, but that's what Match does. For example, if the
array is 0 2 1 and you search for 1, Match returns 1 (the index of the 0), not
3 (the index of the 1).
--
You are receiving this mail because:
You are the assignee for the bug.
