A user wants to take one row of a worksheet and move it up above several other rows (or down below several other rows), without overwriting nor replicating any rows. * Cutting and Pasting doesn't do this. * Cutting and Pasting-special doesn't do this. * No context-menu command, when the row is selected, does this. * I don't see any toolbar button which does this. * I don't see any menu item for does this. * Click-dragging a selected column doesn't do this. * Shift-dragging a selected column doesn't do this. * Ctrl+Shift-dragging a selected column doesn't do this. * Alt-dragging or Alt-Shift a selected column - on Linux at least - moves the window, i.e. the window manager captures that. * Alt+Ctrl-dragging a selected column does something similar - adding a copy at the target position. Although - eveni that has poor graphical indication, as we don't see a thick line between existing rows as a placeholder for the new row; instead, we see a list of rows to cover. Even if, somehow, on Windows, Alt-dragging did work - this is not intuitive enough, not discoverable enough, by users. We need to make this action easier to notice and easier to take. ... the situation is mostly similar for columns.
Could imagine a command uno:ExchangeDown/Up/Left/Right maybe activated per alt+ctrl+cursor that exchanges the content of the current row/column with the neighboring (plus moving the focus).
Mark the row (or column). Set cell cursor to first cell in row (or Column) and drag it to the desired position. While dragging hold down Alt-key. The insert position is then marked with a thick line. The move itself is _very_ slow. You need to wait about 3 seconds.
(In reply to Heiko Tietze from comment #1) > Could imagine a command uno:ExchangeDown/Up/Left/Right Is there currently an UNO command relating to this functionality, at all? Specifically, a command for cutting a row rather than a row's contents, and pasting a row above/below the current row? And now that I've said that - this distinction may be meaningful in itself: Copy/Cut an element vs copy/cut its contents. Relevant to rows and columns (maybe also to other entities? I wonder). > maybe activated per > alt+ctrl+cursor that exchanges the content of the current row/column with > the neighboring (plus moving the focus). A shortcut like that would improve things somewhat, but it's not enough. Although, that particular key combination is likely to already be taken by the Window manager.
(In reply to Regina Henschel from comment #2) > Mark the row (or column). Set cell cursor to first cell in row (or Column) > and drag it to the desired position. While dragging hold down Alt-key. The > insert position is then marked with a thick line. The move itself is _very_ > slow. You need to wait about 3 seconds. Doesnt work here ( debian12 with lxde ) »Alt+drag« is reserved for »move whole window« by window-manager! sor far I did not find a working <key>drag-combi
(In reply to Regina Henschel from comment #2) > Mark the row (or column). Set cell cursor to first cell in row (or Column) This part happens automatically when I select the whole row (or column) > and drag it to the desired position. While dragging hold down Alt-key. Can't do that on my desktop environment (Cinnamon on Linux) - Using Alt+Drag moves the window... But even if this wasn't the case, I believe that's not enough. It is very easy for users not to realize that's available. I should also mention that pressing any of the Alt, Ctrl and Shift keys does not change the appearance of the row or column selection rectangle, or of the selection area, or of the row or column header, nor of the cursor - which further 'masks' the hold-key-and-drag functionality from being figured out by the user.
(In reply to Eyal Rozenberg from comment #5) > (In reply to Regina Henschel from comment #2) > > Mark the row (or column). Set cell cursor to first cell in row (or Column) > > This part happens automatically when I select the whole row (or column) > > > and drag it to the desired position. While dragging hold down Alt-key. > > Can't do that on my desktop environment (Cinnamon on Linux) - Using Alt+Drag > moves the window... From bug 47017 I guess, that it has to be Alt+Shift on Linux. If that is true, then the OS dependency is missing in https://help.libreoffice.org/master/en-US/text/scalc/guide/move_dragdrop.html. For a request for a solution in context menu see bug 39936. The move feature itself was introduced in OOo with https://bz.apache.org/ooo/show_bug.cgi?id=7180 and specified there in http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt.
A request for a solution using the row (or column) header is already in bug 46930.
The move by drag&drop problem for Mac OS is in bug 58440. I find a similar request to this one in bug 143235. The lot of similar requests and their duplicates show, that there need to be an enhancement. The question is, where to track it.
(In reply to Regina Henschel from comment #7) > A request for a solution using the row (or column) header is already in bug > 46930. So make it a duplicate?
Yes, let's take bug 143235 to track the problems. *** This bug has been marked as a duplicate of bug 143235 ***
Better bug 39936, which has already a list of similar duplicate reports. *** This bug has been marked as a duplicate of bug 39936 ***
(In reply to Heiko Tietze from comment #9) > So make it a duplicate? No, a dependent. If that were implemented, the situation would improve, but not be fully resolved.