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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
