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 98562 - data loss on insert
data loss on insert
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Low minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 617151 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2002-11-15 05:17 UTC by Adrian Custer
Modified: 2010-04-30 22:48 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Adrian Custer 2002-11-15 05:17:23 UTC 
If insert is used when a row/column is full, data falls off then end
without warning to the user.

1) new gnumeric
2) A1 gets 1
3) B1 gets =A1+1
4) drag fill entire row
5) select column IU
6) right click -> insert
==> the data in cell IV falls off the edge. It would be nice to get a
warning of some kind.

cheers,
adrian
Comment 1 Morten Welinder 2002-11-17 22:30:38 UTC 
Well, yes, that's the way it goes in a finite universe.
I'm not sure it's worth fixing.  Undo should bring things back.
Comment 2 Morten Welinder 2005-05-25 15:28:46 UTC 
For the record, Excel seems to simply refuse to toss contents off the edge.
(I am not sure what is considered contents here.)
Comment 3 Morten Welinder 2010-04-29 15:17:28 UTC 
*** Bug 617151 has been marked as a duplicate of this bug. ***
Comment 4 Snark 2010-04-29 16:58:36 UTC 
Undo is pretty nice when you get notified that something happened. My wife got hit because she was adding columns at the start, repeatedly (over weeks)... then one day realized she had lost some of her work.

Data loss with no warning : bad.

I see three decent ways out :
1) the user should either be warned that the new column can't be inserted (and it shouldn't be inserted, of course) ;
2) the sheet should be auto-resized to accomodate ;
3) the insert column action should be disabled.

I can't believe silent data loss is seen as low and minor importance...
Comment 5 Andreas J. Guelzow 2010-04-30 18:33:30 UTC 
Snark's suggestion (1) is now implemented for insertions of whole rows or columns.
Comment 6 Andreas J. Guelzow 2010-04-30 22:48:26 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.