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 603933 - Moving a row with formulae is tedious - need "insert cut cells" feature
Moving a row with formulae is tedious - need "insert cut cells" feature
Status: RESOLVED DUPLICATE of bug 8603
Product: Gnumeric
Classification: Applications
Component: General
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Reported: 2009-12-06 22:54 UTC by Jeffrey Ross
Modified: 2009-12-06 23:43 UTC
See Also:
GNOME target: ---
GNOME version: ---

Shows the move-row issue in 3 steps (2.02 KB, application/x-gnumeric)
2009-12-06 22:54 UTC, Jeffrey Ross

Description Jeffrey Ross 2009-12-06 22:54:21 UTC
Created attachment 149215 [details]
Shows the move-row issue in 3 steps

On a sheet where there are formulae, eg column A contains values and column B contains cumulative totals, moving a row further down the sheet is rather difficult.  First the new row location must be created as a blank row, but the cumulative formula for the line below is distorted, eg if B5 contained =B4+A5 the cell that it moves to (B6) becomes =B4+A6 (which is going to be a problem later on).  Next, the row to be moved is copied and pasted over the newly inserted blank row (noticing that the total at the bottom doesn't change, which is sad).  Finally the original row is deleted and the formulae below it all show "#REF!".
The user is then left to repair the damage.
The Excel feature "insert cut cells" is very useful and some equivalent in Gnumeric would make such work much more pleasant and less prone to error.
Thanks for your great product!
Comment 1 Andreas J. Guelzow 2009-12-06 23:43:51 UTC

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