[Libreoffice-bugs] [Bug 107459] MATCH with third parameter MatchType= -1 fails if the SearchVector is passed directly as the result of an array-formula.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Apr 30 14:27:20 UTC 2017


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

--- Comment #3 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 132971
  --> https://bugs.documentfoundation.org/attachment.cgi?id=132971&action=edit
Sample file

N(In reply to Wolfgang Jäger from comment #2)
> (In reply to m.a.riosv from comment #1)
> > 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.

http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.pdf
page 133.
Syntax: MATCH(Scalar Search ;Reference|Array SearchRegion [;Integer MatchType =
1 ]

Hi @Eike, @Winfried some light.

-- 
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/20170430/9efb87da/attachment-0001.html>


More information about the Libreoffice-bugs mailing list