[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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #5 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(In reply to Wolfgang Jäger from comment #4)
>..............
> 
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.

> Is there a draft for a next version of odf (recalc) concerning this?
https://www.oasis-open.org/committees/document.php?document_id=51469&wg_abbrev=office-collab

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.

-- 
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/20170501/bfd7c5be/attachment.html>