https://issues.apache.org/ooo/show_bug.cgi?id=122831
Bug ID: 122831
Issue Type: DEFECT
Summary: Bug in array formula containing IF
Product: Calc
Version: AOO 4.0.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81138
--> https://issues.apache.org/ooo/attachment.cgi?id=81138&action=edit
Bug in simple array formula
In a simple one-cell array formula, entered in cell A2
=IF(A1<>"";A3;6)
Which starts with A1 blank. If something is then entered in A1, with a number
in cell A3, the ELSE part of the IF changes to the value in A3, so if A3
contains 9, the formula in A2 changes to
=IF(A1<>"";A3;9)
It appears to be that the actual formula value is being fed into the ELSE part.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
