[Libreoffice-bugs] [Bug 118561] Calc: How to do this special lookup in external file? Arrays on IF function.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |
             Status|NEW                         |ASSIGNED

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
This boils down to an external reference not being supported in the THEN or
ELSE paths of an IF jump if in array/matrix mode. Short reproducer:

=IF('problem_2_external_file.ods'#$external_data.B$1:B$9=B14,'problem_2_external_file.ods'#$external_data.C$1:C$9)

entered in any cell of problem_2_main_file.ods as array formula (closed with
Shift+Ctrl+Enter) for the preselected fruits case in B14 displays the first 5
values as Err:502 (which should be the matching 5 fruits) followed by 4 values
FALSE (as there are no more matches for fruits in the range).

Taking.

-- 
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/20180706/fd4d7699/attachment.html>