After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 433907 - insert row or cells causes formulas to be updated incorrectly
insert row or cells causes formulas to be updated incorrectly
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.7.x
Other All
: High major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 437389 439343 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2007-04-27 16:35 UTC by Marlon Nelson
Modified: 2011-09-30 19:23 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Marlon Nelson 2007-04-27 16:35:28 UTC 
I'm running Ubuntu 7.04, gnumeric 1.7.8

this bug was driving me nuts until i figured out what was going on

To reproduce:

1) new workbook

2) Sheet1
   A1=1000
   A2=2000
   A3=3000
   ...

3) Sheet2
   A1=1000
   A2=2000
   B1=sum(Sheet1!A:A)+A1+A2
   C1=Sheet1!A1+A1+A2

4) Sheet1
   Insert a new row between rows 1 and 2 -or-
   Insert a new cell between A1 and A2


Results:

In Sheet2

   B1 changes to "sum(Sheet1!A:A)+A1+A3" as if a row had also been inserted between 1 and 2 in Sheet2

   C1 stays unchanged as expected


Note:

Same bug if you use average() instead of sum().  I suspect any function would show the problem.


The End.
Comment 1 Jody Goldberg 2007-04-28 01:14:15 UTC 
replicated.  I see the problem.  A simpler example is 

Sheet2!A1 : =Sheet1!A:A+B2
insert row in Sheet 1

I'm working on a patch.
Comment 2 Jody Goldberg 2007-04-28 01:49:32 UTC 
Excellent!  This was actually 2 distinct bugs.
1) mis-calculated the referenced sheet so we thought B2 was Sheet1!B2
2) which masked the lack of a test not to relocate Sheet2!B2

Patch will be in 1.7.10
Comment 3 Marlon Nelson 2007-04-28 20:57:06 UTC 
> Excellent!

yes... very much so... thanks!

i never had this much success reporting a problem with MS/Excel

i compiled v1.7.10 and it's working as i expect it to
Comment 4 Jody Goldberg 2007-05-10 21:27:21 UTC 
*** Bug 437389 has been marked as a duplicate of this bug. ***
Comment 5 Morten Welinder 2007-05-18 13:01:33 UTC 
*** Bug 439343 has been marked as a duplicate of this bug. ***