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 123326 - Wishlist: Paste Special -> [x] Don't change formulae
Wishlist: Paste Special -> [x] Don't change formulae
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: GUI
git master
Other All
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 434167 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2003-09-26 17:41 UTC by Luke Hutchison
Modified: 2009-12-31 01:57 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Luke Hutchison 2003-09-26 17:41:10 UTC 
It would be nice to be able to paste without having Gnumeric change the
formulae that are being pasted, temporarily treating them as absolute
references and not relative references for duration of the paste operation.
 It happens a lot that I have a column of formulae that contain some
relative references, then I need a column that is very similar but needs
some modifications in the formulae.  When going copy->paste, all those
relative refences change, and I have to go back through and change them
back to what they originally said before pasting.

The Paste Special box is probably a natural place for this option.
Comment 1 Jody Goldberg 2004-09-28 05:17:13 UTC 
This is still a good idea.  It would be a good project for someone.
Comment 2 Morten Welinder 2004-09-29 17:09:33 UTC 
You can actually get this effect by using copy and paste in the edit line.
(That is textual copy and paste.)

Not very elegant, but at least possible.
Comment 3 Luke Hutchison 2004-09-29 17:26:23 UTC 
:) True.  Doesn't work for copying/pasting a whole range of formulae at once though.
Comment 4 Andreas J. Guelzow 2009-10-15 18:27:27 UTC 
*** Bug 434167 has been marked as a duplicate of this bug. ***
Comment 5 Andreas J. Guelzow 2009-11-27 00:40:07 UTC 
*** Bug 584414 has been marked as a duplicate of this bug. ***
Comment 6 Andreas J. Guelzow 2009-12-31 01:57:15 UTC 
It seems that all the required code with the exception of the user interface was already in place.

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.