https://bugs.freedesktop.org/show_bug.cgi?id=80195
Priority: medium
Bug ID: 80195
Assignee: [email protected]
Summary: EDITING: IFERROR() fails to evaluate to alternative
value (2nd parameter)
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 101315
--> https://bugs.freedesktop.org/attachment.cgi?id=101315&action=edit
example that demonstrates the bug
Problem description:
A cell containing an IFERROR() formula does not evaluate to the specified
"alternative value" under certain conditions. In the example, the test
expression (first parameter of IFERROR()) is itself an expression built with
IF(). The inner IF has a condition that cannot be evaluated.
Placing the (inner, failing) IF() expression and the (outer) IFERROR()
expressions in separate cells produces correct result - "alternative value"
specified on 2nd parameter of IFERRROR() is returned.
However, if the two cells are merged into a single expression (instead of a
reference to the IF() formula, it is copied verbatim inside the IFERROR()
formula), the IFERROR does not return the "alternative value", but an error
(which is exactly the opposite of why it has been used in the first place - to
avoid an error in a cell).
Steps to reproduce:
1. open a new sheet
2. place the following formula in any cell:
=IFERROR(IF("foo"+1<=1,0,1),"alternative value")
3. observe the result of the formula
Current behavior:
The formula returns an error
Expected behavior:
The formula should return "alternative value"
Example sheet:
The attached example also shows that if the two formulas are placed into
separate cells (i.e. the failing IF() is in a cell, and the IFERROR is in
another cell that references the first one), then the IFERROR produces a
correct value.
However, in a single expression, IFERROR produces incorrect value.
Operating System: Ubuntu
Version: 4.2.3.3 release
--
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
