GNOME Bugzilla – Bug 106148
sum(A1:A2) with cutting and pasting of A1 / A2 doesn't work
Last modified: 2004-12-22 21:47:04 UTC
[Originally reported as http://bugs.debian.org/181059] From: trini@kernel.crashing.org Subject: Bug#181059: gnumeric: sum(A1:A2) with cutting and pasting of A1 / A2 doesn't work Package: gnumeric Version: 1.1.16-4 Severity: normal The following bugreport should probably be sent upstream: The following sequence no longer works: A3 is set to '=sum(A1:A2)' A1 and A2 are assigned numeric values A1 or A2 is cut (Control-X) and pasted into another field. At this point A3 still has the sum of A1 + A2. Additionally, if A1 is cut and then pasted into say, B1, cutting B1 and pasting back into A3 results in #REF! (the cell is set to '=sum(#REF!)
This looks like correct behaviour to me. What, exactly, is the behaviour you want?
I'm not sure about the second part of the submitter's report, but I concur that the first part is an issue: A3 is set to '=sum(A1:A2)' A1 and A2 are assigned numeric values A1 or A2 is cut (Control-X) and pasted into another field. At this point A3 still has the sum of A1 + A2. IMO, a recalc of the sheet should have been triggered by the paste.
You're correct. It should have recalced when the cell was moved and also when the move was undone. This bug is was not in the 1.0.x series and is now fixed. Thanks for finding this it was a bit subtle. Patch will be in 1.1.17