https://bugs.documentfoundation.org/show_bug.cgi?id=95226
Bug ID: 95226
Summary: IFERROR not working correctly under array-evaluation
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119828
--> https://bugs.documentfoundation.org/attachment.cgi?id=119828&action=edit
Demo as mentioned in the bug description
Steps to reproduce the bug:
1. Create a new Calc document with V4.4.4 or higher.
2. Enter 1, =NA(), and =PI() into A1, B1, C1 respectively.
3. Type =IFERROR(A1:C1;"Error!") into A2 and enter this as an array-formula
(Ctrl+Shift+Enter).
Expected result:
1, #N/A, 3,1415926536 displayed in A2:C2 consecutively.
Actual result:
1, #N/A, #NA in the respective cells.
The attached erxample is also demonstrating slightly extended examples and the
complications to be accepted using a workaround (redundant calculation again
which to avoid IFERROR was invented for).
The bug is partly debasing the IFERROR function concerning its intention to
avoid redundant (second) evaluation.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
