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 545262 - Auto-cohesive shifting of cells
Auto-cohesive shifting of cells
Status: RESOLVED DUPLICATE of bug 8603
Product: Gnumeric
Classification: Applications
Component: Main System
git master
Other All
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Reported: 2008-07-29 05:50 UTC by kxroberto
Modified: 2008-08-06 10:37 UTC
See Also:
GNOME target: ---
GNOME version: ---

Description kxroberto 2008-07-29 05:50:07 UTC
Very often I have to do steps like these, in order to simply shift cells (most time lines or columns):

* insert 33 extra empty lines as space for 33 lines to move from elsewhere.
* mark&cut the other 33 lines
* paste the lines to the created empty space; hope that the number of lines matches - often errors...
* go down to original cut space - empty now. Mark again and eliminate the lines 

Feels like doing 100 tasks - in order to manage a simple shift task as it is standard behavior in a text editor with simple cut&paste.

Possible solution: There could be a "Shifting" special pasting mode upon a Cut. I think this option is not in my version of Excel also - missing there as well. Would provide a great speed up.

Other information:
Comment 1 Jody Goldberg 2008-07-29 23:53:04 UTC
I'm not clear on the goal.

are not sufficient ?
Comment 2 kxroberto 2008-07-30 06:29:18 UTC
To me: No.
These keystrokes (after Shift-Space etc.) were assumed implicit in the task list above.

I often have to shift cells this way (most times/90% lines; >90% of cases vs. current "Overwrite-Move"), and each time remember the fluid behavior of text editors - sighing. 
I'd even wish a extra key binding for that - like Ctrl-Alt-V.  Or: if Ctrl-Shift-V is anyway not active after Ctrl-X now and in future, then it would be quite natural to bind the free Ctrl-Shift-V  after Ctrl-X to "Shifting-Move" (without further dialog in trivial cases)
Comment 3 Morten Welinder 2008-07-30 12:10:54 UTC
Could you please make an example that clearly shows what you start with
and what you would like to end with?  ("Explicit" and in "Put XXX in A1...")
Comment 4 Andreas J. Guelzow 2008-08-01 17:47:55 UTC
I think we have this request already in another bug report:

enter content in columns A, B, C, D, E and F
Now you want to move the content of D and E to be between the content of A and B, 


Content of A stays put.
Old content of D becomes content of B.
Old content of E becomes content of C.
Old content of B becomes content of D.
Old content of C becomes content of E.
Content of F stays put.

Currently this involves:
counting number of columns in E to F (that's 2 in this case)
inserting columns between A anb B
copying (old) columns D & E
pasting into new B & C
deleting (old) columns D & E
Comment 5 kxroberto 2008-08-03 07:06:11 UTC
yes, or when shifting 2 lines (just like in a text editor):


1	text1
2	text2
3	text3
4	text4
5	text5
6	text6
7	text7
8	text8


1	text1
2	text2
6	text6
7	text7
3	text3
4	text4
5	text5
8	text8

Comment 6 Morten Welinder 2008-08-03 16:51:42 UTC
Ah.  I would call that rotating a region.
Comment 7 Jody Goldberg 2008-08-06 10:37:12 UTC

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