<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - MATCH gives incorrect result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144770#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - MATCH gives incorrect result"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144770">bug 144770</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>