Apache OpenOffice (AOO) Bugzilla – Issue 40285
Quickly move Rows and columns like in Writer
Last modified: 2013-08-07 15:12:27 UTC
In Writer i can Move Paragraphs up and down using Ctrl-Alt-Up/Down. I would like to move Rows/Columns/Cells in Calc the same way.
MS Office has this, according to #19932. Re-posted 19114 with correct summary (old one misunderstandable).
Hi, as you stated before, this is a double to Issue 19114 and *not* related to Issue 19932. Frank *** This issue has been marked as a duplicate of 19114 ***
closed double
So i have to be a bit more verbose: - this is not a double of issue 19114 - 19114 summary: Quickly move rows/cols AND assign this feature to ctrl-up/dn" - 19114 was closed by bh because "this feature would collidate with accessibility." she didnt explain this so i can only guess this is about the suggested kbd shortcut. i can not imagine how this feature itself could "collidate with accessibility" - at the end it is implemented in writer, but not in calc. so i think her decision is about the suggested keyboard assignment - as i can not change the summary i posted this one with now correct summary
.
Confirmed. Priority is P4. To "aexl": Can you shortly describe what exactly should happen if, f.e., a cell is highlighted and Ctrl-Alt-Up is pressed. I expect it should - as in Writer - swap the contents of the highlighted cell with the one contents of the cell above. Now, how do you think, swapping(moving) whole lines/colums should work? Please consider, that in contrast to Writer there might be lots of references to the cell(s) of interest and the ones next to them. How to handle that? Maybe equal to moving cells with drag-and-drop?
>Can you shortly describe what exactly should happen if, f.e., a cell is highlighted and Ctrl-Alt-Up is pressed. >I expect it should - as in Writer - swap the contents of the highlighted cell with the one contents of the cell above. >Now, how do you think, swapping(moving) whole lines/colums should work? My Suggestion: - ctrl-alt-cursor = move row or column (because you (at least i ;-) need this much more often) - shift-ctrl-alt-cursor = move cell >Please consider, that in contrast to Writer there might be lots of references to the cell(s) of interest and the ones next to them. >How to handle that? Maybe equal to moving cells with drag-and-drop? Right. We have to preserve all references! Please see my StarBasic Implementation for further details. Might serve as a starting point...
Created attachment 22899 [details] StarBasi Implementation for issue 40285
> ctrl-alt-cursor That would be great, but I notice in OOo 2.0.0 (Win XP Pro) that the Alt key is not available for any keyboard assignments :( As a general point, this greatly reduces the available key combinations, or means sacrificing existing default assignments, which isn't ideal. I have searched "alt key" but cannot find an issue on this, only Alt+Gr issues?
I would like the enhancement to go further. In the spreadsheet I previously used, it was possible to grab a row or column (probably by using the header, I forget) with the mouse and drag it to the desired position.
Contender: Drag&Drop with mouse is already available since issue 7180 is fixed. This issue is about moving with the keyboard.
Hi, I need this feature. What does P4 priority mean? When it will be done? Are there some patches floating around? I can recompile whole openoffice without any problems, with a patch applied.
@cosurgi: seen my userland solution? get an improved version at http://ooomacros.org/user.php#146632 ps: hooray to the developers! as issue 4756 is fixed in 3.2 we can assign alt-key shortcuts. YES WE CAN!
are there any plans to add this feature ?
Thanks to the efforts by aexl, here is another workaround https://bitbucket.org/tora/calc-move-selected-cells/src/tip/src/
Oops, there was a typo bug. Now fixed: https://bitbucket.org/tora/calc-move-selected-cells