[Libreoffice-bugs] [Bug 107459] New: MATCH with third parameter= -1 fails if the SearchVevtor 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

            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: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170426/7ebedcb4/attachment.html>