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 304642 - #REFERR# when removing first line in sum
#REFERR# when removing first line in sum
Status: RESOLVED DUPLICATE of bug 67634
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-05-18 11:34 UTC by Jon Kåre Hellan
Modified: 2005-05-23 17:18 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Jon Kåre Hellan 2005-05-18 11:34:42 UTC 
On behalf of olav kvittem at uninett no:
> I get a #REFERR# when removing line 28 in
> http://domen/testnett/plan-2005/ressursplan.gnumeric
> using gnumeric 1.2.13 (fc3).
> this line is the first in a range sum at line 33. I would
> expect the range to be adjusted.

Confirmed.

CVS HEAD has the same behaviour. Excel and OOo Calc behave the way you
expect.
Comment 1 Jon Kåre Hellan 2005-05-19 08:53:21 UTC 
Please disregard the URL. I should have removed it before reporting, and it
doesn't work anyway.
Comment 2 Jon Kåre Hellan 2005-05-20 13:29:19 UTC 
I reproduced the problem by entering 1's in A2,A3 and A4, and =SUM(A2:A4) in A6.
I then marked row 2 and deleted it. This resulted in #REFERR#, like my colleague
saw.
Comment 3 Andreas J. Guelzow 2005-05-20 16:36:50 UTC 
I think this is in fact the same bug as 67634 (which we were going to fix after 1.0)
Comment 4 Morten Welinder 2005-05-23 17:18:40 UTC 
"after 1.0" is not, strictly speaking, wrong, :-)


*** This bug has been marked as a duplicate of 67634 ***