[Libreoffice-bugs] [Bug 113898] New: Cross-Document reference in array formula using FIND/ ISERROR does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113898
           Summary: Cross-Document reference in array formula using
                    FIND/ISERROR does not work
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tilman.vogel at web.de

Created attachment 137824
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137824&action=edit
First sheet showing how the formula works correctly within a single sheet.
Second sheet referencing the first and exhibiting the problem follows.

Version: 5.3.3.2
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448

When I use a SUMPRODUCT() formula referencing a range in a separate document
and using FIND() in conjunction with ISERROR(), I don't get correct results -
sometimes wrong results, sometimes #VALUE.

I'll attach two example sheet documents

-- 
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/20171117/e139af59/attachment.html>