GNOME Bugzilla – Bug 135609
Range lost
Last modified: 2004-12-22 21:47:04 UTC
[Originally reported as http://bugs.debian.org/235120] Subject: Bug#235120: gnumeric: range in $B$1:$B1 lost on save From: Philipp Matthias Hahn <pmhahn@debian.org> Date: Fri, 27 Feb 2004 15:46:12 +0100 Message-Id: <20040227144612.4559A175DF@walker.pmhahn.de> Package: gnumeric Version: 1.2.6-1 Severity: normal gnumeric simplifies to much on save and looses the range: 1. Create sheet with A1: =sum($B$1:$B1) 2. Copy A1 and paste to A2 3. Save to file 4. Load from file 5. A2 now reads: =sum($B$1) You can also grep the file directly and find it saved wrong: $ zgrep ExprID Book1.gnumeric <gmr:Cell Col="0" Row="0" ExprID="1">=sum($B$1)</gmr:Cell> <gmr:Cell Col="0" Row="1" ExprID="1"/>
Here's an annotated and extended version of the recipe: 1. Set A1 to `=sum($B$1:$B1)' Observe that A1 is (correctly) simplified to `=sum($B$1)' in the expression entry widget. 2. Copy A1 and paste to A2 Observe that the formula in A2 has become `=sum($B$1:$B2)', i.e. it has been based on the formula originally entered in A1, not on the simplified formula displayed for A1. 2b. Set B1 to `10'. 2c. Set B2 to `100'. Observe that the value of A1 is now `10' and that of A2 is now `110'. 3. Save to file Observe that in the saved file A1 has the simplified expression: <gmr:Cell Col="0" Row="0" ExprID="1">=sum($B$1)</gmr:Cell> and that A2 incorrectly has become a reference to that expression: <gmr:Cell Col="0" Row="1" ExprID="1"/> 4. Load from file 4b. Observe that A2 now has the value `10' rather than the `110' intended by the user.
This is not save-related, per se. If you go back to A1 you will see "=SUM($B$1)". CVS is affected too.
Fixed in cvs.