[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]

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

--- Comment #2 from Wolfgang Jäger <jag at psilosoph.de> ---
(In reply to m.a.riosv from comment #1)
> The issue with your second formula is the use of '0+' as array modification,
> with a modification different than '0', or with any other modification or a
> clean array works fine for me.
> 
> 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?

Of course, the "0+" is only the extreme simplification of what I had originally
when I discovered the bug. There are also relevant formulas resulting in arrays
to pass to MATCH in the second place. 
In fact I discovered the bug when I tried to get a REVERSE MATCH against an
ascending column-array by something like 
{=MATCH(Value;INDEX($B$1:$B$10;ROW($B$10)-ROW($B$1:$B$10)+1;1);-1)}
I did not find too easily the way back to the root of the bug: making a
difference between an array referenced directly and one with the identical
elements calculated in the parameter position where it's used. 
The bug is from ancient days and seemingly was not reported all the time. It's
a bug nonetheless. And it may e.g. throw light on a flaw in the design of the
code concerned with array evaluation generally. It may also be an isolated
problem with MATCH.

-- 
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/20170429/8a606536/attachment.html>