<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - MATCH with third parameter MatchType=-1 fails if the SearchVector is passed directly as the result of an array-formula."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107459">bug 107459</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - MATCH with third parameter MatchType=-1 fails if the SearchVector is passed directly as the result of an array-formula."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107459#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - MATCH with third parameter MatchType=-1 fails if the SearchVector is passed directly as the result of an array-formula."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107459">bug 107459</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>(In reply to Wolfgang Jäger from <a href="show_bug.cgi?id=107459#c4">comment #4</a>)
<span class="quote">>..............
> </span >
For me, if it is not explicit, it's not explicit, and I can't interpreter as I
like.
Even I think I understand your interpretation, that sounds reasonable.
<span class="quote">> Is there a draft for a next version of odf (recalc) concerning this?</span >
<a href="https://www.oasis-open.org/committees/document.php?document_id=51469&wg_abbrev=office-collab">https://www.oasis-open.org/committees/document.php?document_id=51469&wg_abbrev=office-collab</a>
In any case testing with a inner array gives what seems an erroneous result
=MATCH(5;{20;19;18;17;16;15;14;13;12;11;10;6;6;5;5;4;4;3;2;1};-1) = 14
1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 20
If I'm not wrong result should be 15 as happens with an unmodified address
array.</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>