<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - MATCH with third parameter=-1 fails if the SearchVevtor is passed directly as the result of an array-formula."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107459">107459</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>MATCH with third parameter=-1 fails if the SearchVevtor is passed directly as the result of an array-formula.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jag@psilosoph.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=132876" name="attach_132876" title="Demonstration announced in the original bug report">attachment 132876</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132876&action=edit" title="Demonstration announced in the original bug report">[details]</a></span>
Demonstration announced in the original bug report
{=MATCH($E3;$C$3:$C$11;-1)} e.g. is returning the correct result even if it is
unnecessarily entered for array evaluation.
{=MATCH($E3;0+$B$3:$B$11;-1)} returns the position of the wrong end if the
SearchVector is containing a group of equal values determining the match.
In the attached example this is demonstrated for the case that C3:C11 is
calculated by exactly the same trivial array formula provoking the error if
directly passed to MATCH.
The bug may have sparse gray hair, and the demonstrated case is not realistic.
There ARE applications of some interest, and it's a bug anyway.</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>