Issue 122831 - Bug in array formula containing IF
Summary: Bug in array formula containing IF
Status: CONFIRMED
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: RottenEogat@gmail.com
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Bug in simple array formula (8.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-07-24 22:25 UTC, charlie_young 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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

=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.
Comment 1 Joe Smith 2013-07-25 00:58:29 UTC 
More discussion here:
http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=62940

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
Debian