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 439347 - =sum(xx:yy) broken on delete cell yy
=sum(xx:yy) broken on delete cell yy
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
1.7.x
Other Linux
: High normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-05-18 03:41 UTC by Jose Da Silva
Modified: 2007-07-25 23:35 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
spreadsheet with A2...A7 filled in with data and pointing to cell A6 (1.82 KB, application/octet-stream)
2007-05-18 03:44 UTC, Jose Da Silva 		Details

Description Jose Da Silva 2007-05-18 03:41:35 UTC 
If you have data in cells A2..A6 and you have cell A7 "=sum(A2:A6)" and you attempt to delete cell A6, then you have an error because now cell A6 contains "=sum(A2:A6)"

The correct data should have been updated to "=sum(A2:A5)"

#1)To reproduce the bug, enter data in:
A2=1
A3=2
A4=3
A5=4
A6=5
A7=sum(A2:A6)

#2)Now delete cell A6 - go to menu-Edit->Delete->Cells
#3)The pop-up says up (if not, please select move-up). Click okay to continue
#4)Cell A6 gets deleted and cell A7 moves up into cell A6 but does not get modified to "sum=(A2:A5)"

Note: The problem also happens if you select a block of cells such as selecting cells A5 and A6 and then going to the menu to menu-Edit->Delete->Cells
Comment 1 Jose Da Silva 2007-05-18 03:44:48 UTC 
Created attachment 88371 [details]
spreadsheet with A2...A7 filled in with data and pointing to cell A6

I have included a gnumeric spreadsheet filled with data A2...A7.
If you point at A6 and delete the cell (upwards) it should cause the error of not updating =sum(A2:A6) to the new value of =sum(A2:A5)
Comment 2 Jody Goldberg 2007-07-23 01:45:58 UTC 
Working on a patch.

The problem was fixed for ins/del cols/rows.  However, my heuristics get tossed here because the clearing operation moves the old content in both directions.
Comment 3 Jody Goldberg 2007-07-25 23:35:00 UTC 
Patch is in 1.7.11