https://bugs.documentfoundation.org/show_bug.cgi?id=107459
Bug ID: 107459
Summary: MATCH with third parameter=-1 fails if the
SearchVevtor is passed directly as the result of an
array-formula.
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 132876
--> https://bugs.documentfoundation.org/attachment.cgi?id=132876&action=edit
Demonstration announced in the original bug report
{=MATCH($E3;$C$3:$C$11;-1)} e.g. is returning the correct result even if it is
unnecessarily entered for array evaluation.
{=MATCH($E3;0+$B$3:$B$11;-1)} returns the position of the wrong end if the
SearchVector is containing a group of equal values determining the match.
In the attached example this is demonstrated for the case that C3:C11 is
calculated by exactly the same trivial array formula provoking the error if
directly passed to MATCH.
The bug may have sparse gray hair, and the demonstrated case is not realistic.
There ARE applications of some interest, and it's a bug anyway.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
