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 513053 - Names in sheet - moving problems
Names in sheet - moving problems
Status: RESOLVED DUPLICATE of bug 123649
Product: Gnumeric
Classification: Applications
Component: General
1.6.x
Other All
: Normal minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-01-30 10:11 UTC by Martin Proks
Modified: 2008-01-30 15:00 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Martin Proks 2008-01-30 10:11:01 UTC
Gnumeric 1.6.3 - Linux Fedora 7 x86_64
But probably the same problem is in newer Gnumeric versions too.

I created a sheet in a gnumeric and I defined some Named cells (Insert -> Define names). Next I needed to move the cells (CTRL-X ... CTRL-V), but the names stay attached to the original cells, not to the new posittions. The same when I deleted some rows (Edit .. Delte .. Rows) or collumns.

For example:

Some_name - define it at cell A3 and fill it by value 2.1
Cell A4 is empty
Cell A1 "=Some_name" ... value 2.1
Now delete full row A2 by click to A2 amd Edit -> Delete -> Row
Value from A3 is moved to A2, value from A4 is moved to A3 (this is OK)
But cell A1 loss reference, "=#REF!" and "Some_name" stay attached at A3 (this is wrong).

I thing the right and logical behavior is, when I delete row A2, the "Some_value" will be reattached to A2 and A1 doesn't loss connection to the name "Some_value".

The same problem and the same expected behavior is about CTRL-X .. CTRL-V.

Best regards,
Martin Proks

Other information:
Comment 1 Morten Welinder 2008-01-30 15:00:43 UTC

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