[Libreoffice-bugs] [Bug 144770] MATCH gives incorrect result

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
Why do you think this is supposed to work? Unlike the similar construct with
LOOKUP(2;1/...) (which is a special case), MATCH() for an array passed does not
ignore error values nor does it magically sort the array, so with
{~DIV/0!;~DIV/0!;~DIV/0!;~DIV/0!;1;~DIV/0!;~DIV/0!}
a range search, as the third argument is not given the data MUST be strictly
sorted ascending, in such unsorted array may yield arbitrary results.

The cited help text "This applies even when the search array is not sorted" is
simply wrong. I don't know where the author got that idea from.

-- 
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/20210928/d7d46610/attachment.htm>