<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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 <a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> m.a.riosv</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132971" name="attach_132971" title="Sample file">attachment 132971</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132971&action=edit" title="Sample file">[details]</a> Sample file N(In reply to Wolfgang Jäger from <a href="show_bug.cgi?id=107459#c2">comment #2</a>) > (In reply to m.a.riosv from <a href="show_bug.cgi?id=107459#c1">comment #1</a>) > > So it can be a trick way to get the reverse behavior. > > Who should have decided to establish that "trick way"? Where is it specified? I didn't say that. I have done a new sample, where to seems the issue is the -1 for third MATCH parameter. But it happens with a modified 'Reference|Array SearchRegion', what I am not sure it is allowed in the specification, at least explicitly. <a href="http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.pdf">http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.pdf</a> page 133. Syntax: MATCH(Scalar Search ;Reference|Array SearchRegion [;Integer MatchType = 1 ] Hi @Eike, @Winfried some light.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>