Issue 122831 - Bug in array formula containing IF
Summary: Bug in array formula containing IF
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-07-24 22:25 UTC by charlie_young
Modified: 2013-12-10 18:21 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.1
Developer Difficulty: ---

Bug in simple array formula (8.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-07-24 22:25 UTC, charlie_young
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description charlie_young 2013-07-24 22:25:59 UTC
Created attachment 81138 [details]
Bug in simple array formula

In a simple one-cell array formula, entered in cell A2


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


It appears to be that the actual formula value is being fed into the ELSE part.
Comment 1 Joe Smith 2013-07-25 00:58:29 UTC
More discussion here:

Just to be clear: entering a value causes a change in the formula text of another cell..

Maybe the bug only affects a corner case, but if it turns out to affect more common cases, it would be a pretty serious bug.
Comment 2 Oliver Brinzing 2013-07-25 05:26:08 UTC
Comment 3 sepana7 2013-11-15 04:36:10 UTC
I was not able to replicate this bug with version 4.0.1 on Windows 7 64-bit. The IF statement worked correctly when I tested it and it never changed the formula. I tested it across multiple different cell formats.
Comment 4 Joe Smith 2013-11-15 14:23:22 UTC
Hmm, I can't seem to reproduce the problem in 4.0.1 either, although it was a bit tricky to see it in the first place. I'm not 100% sure I'm following all the necessary steps to see it now. I haven't saved my install of AOO 4.0 to compare with.
Comment 5 Edwin Sharp 2013-12-10 18:21:33 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1548193
2013-12-07_04:10:48 - Rev. 1548790