[Libreoffice-bugs] [Bug 116100] New: MATCH applied to a search array introduced by an OFFSET subexpression results in Err :504.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116100
           Summary: MATCH applied to a search array introduced by an
                    OFFSET subexpression results in Err:504.
           Product: LibreOffice
           Version: 6.0.2.1 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 140235
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140235&action=edit
The demo mentioned in the text

A formula like =MATCH($B$3;OFFSET($C$3;G3:G8;H3:H8;1;1);0) fails returning
Err:504.
The OFFSET subexpression turned into the formula =OFFSET($C$3;G3:G8;H3:H8;1;1)
elswhere returns the expected array, however.

Conclusion: MATCH does not correctly accept a search array returned by an
OFFSET expression under (iterative) array-evaluation due to arrays on the
second and the third parameter position. 

Older versions evaluate expressions of the mentioned kind correctly as
expected.

I came about this trying to answer a user question about searching in 2D-arrays
in a forum. I tried to reactivate older examples using formulae of the kind
that had worked but did no longer.

A reduced example is attached.

-- 
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/20180301/3dc7b7d8/attachment-0001.html>