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 584414 - Paste special/don't change formulae doesn't work as expected for transposition
Paste special/don't change formulae doesn't work as expected for transposition
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: General
unspecified
Other Linux
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2009-06-01 07:30 UTC by Daniel Vianna
Modified: 2018-05-22 13:32 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Daniel Vianna 2009-06-01 07:30:06 UTC 
I really need this. I need to transpose symlinks, so =A1, =A2, =A3, which exist in a row of cells, is pasted in another sheet as the same in columns, and vice-versa. I don't want the numeric results, I want the symlinks copied. Excel 2007 does not feature that one, guys!
Comment 1 Jody Goldberg 2009-06-01 12:31:43 UTC 
Have you tried making the links use absolute references ?
=$A$1
...
Comment 2 Andreas J. Guelzow 2009-10-15 18:30:01 UTC 
You can also get the same effect using =Transpose(...) entered as an array function.
Comment 3 Andreas J. Guelzow 2009-11-27 00:38:34 UTC 
I guess what you really want is to have the literal formulas copied.
Comment 4 Andreas J. Guelzow 2009-11-27 00:40:07 UTC 
This is therefore a duplicate of bug #123326.

*** This bug has been marked as a duplicate of bug 123326 ***
Comment 5 Andreas J. Guelzow 2009-12-31 02:02:55 UTC 
I am reopening this because the fix of bug #123326 doesn't help yet. Selecting "Don't change formulae" avoids the formula change through translation but transposing and/or flipping still causes a change in formulae.
Comment 6 GNOME Infrastructure Team 2018-05-22 13:32:27 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/118.