GNOME Bugzilla – Bug 545262
Auto-cohesive shifting of cells
Last modified: 2008-08-06 10:37:12 UTC
v1.9.1 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:
I'm not clear on the goal. ctrl-<plus> ctrl-<minus> are not sufficient ?
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)
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...")
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, ie. 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
yes, or when shifting 2 lines (just like in a text editor): before: 1 text1 2 text2 3 text3 4 text4 5 text5 6 text6 7 text7 8 text8 after: 1 text1 2 text2 6 text6 7 text7 3 text3 4 text4 5 text5 8 text8
Ah. I would call that rotating a region.
*** This bug has been marked as a duplicate of 8603 ***