Wikipage about Calc > Moving Cells by Drag-and-Drop here:
has key strokes which do not apply to macOS. macOS users are left in the dark as to how the feature is to be used resulting in rather high frustration.
Steps to Reproduce:
1. Visit https://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop
2. Try to use described key presses
Either nothing happens, or something other than described in the wiki.
Proper behavior as described in the wiki.
User Profile Reset: No
Adding a column to the wiki table with macOS key presses would help. And then again, this is a much bigger issues, since I guess it applies to all wiki pages giving keyboard shortcuts. Not sure how to best solve this large scale.
Sidenote: I have rather strong feelings about the default mode being overwrite. I would expect non-descructive insert mode to be the default and simple to use thing. Remaining data is always removed easily, but once data is lost and maybe lost is not instantly discovered, irredeemable damage may be done.
Confirming with LO6112
Excel's help and the spreadsheet functionality is much easier both to use and understand in this regard.
For example, to move a column of data wherever I want, even in between existing columns :
1) Select the data column header
2) Move the mouse over the frame of selected data, the icon changes to a hand.
3) Press Shift key and drag data column to insert wherever I like. Notice the visual hints also given to the user (similar to LO's tooltip) as to where the column is going to be inserted.
LO in contrast requires a certain degree of manual dexterity to achieve the same thing that would be impossible, or nigh in impossible, for physically impaired users.
In LO367, at leat there is a visual hint when dragging column/row data to a new spot, where a bold line appears to show in between which column/row the data is going to land
The page referred is now
Note that the contents changes when call is from a macOS computer (?System=MAC).
Please check if the contents are correct now and, if not, please provide the equivalent contents changes in the page above, including current valid keyboard shortcuts for macOS in a simple document or comment here and I'll make it go to the help page above.
Created attachment 145050 [details]
alt + drag on macOS 10.13.6 + LO 18.104.22.168
Thanks a lot for clarifying Olivier. I should start using LibreOffice help instead of a search engine to find solutions I guess.
but still do not understand the bevahior.
Issue 1: Why not allow users to drag columns + rows by clicking on the Letter (column) or number (row)?
Issue 2: The KB documement says
Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are."
I tired that but the row I drag to keeps being overwritten and the source fields are not moved but copied. They stay in their original place. This seems to be wrong and not behaving as described.
Can someone double check? Screencast attached (alt ⌘ drag operation.mp4)
Correction: not overwritten. Point being: content is not moved but copied. Really unsure if this is a bug or expected behavior. But I am so far unable to really "move" cells as.
(In reply to steve -_- from comment #7)
> Correction: not overwritten. Point being: content is not moved but copied.
> Really unsure if this is a bug or expected behavior. But I am so far unable
> to really "move" cells as.
Yes, I can confirm that the data is only copied, not moved, when using the Option key.
So this now has the macOS keyboard keys after the move to online help
However, I'm not sure the behavior is as described
Also a separate issue that should be filed: How things look when you drag and drop is also just a "dot", in LO 3.3 you at least also had a grid
Cells are moved and overwrite the cells in the target area. Source cells are emptied.
Actual: Yes (no key on windows)
Cells are copied and overwrite the cells in the target area. Source cells stay as they are.
Actual: Can't hold cmd+click at the same time, only seem to be selecting the cell. If holding cmd while dropping, same result as no key (ctrl key on windows)
Links to the source cells are inserted and overwrite the cells in the target area. Source cells stay as they are.
Actual: Same as above
Workaround: ctrl key achieves the described result! (ctrl+shift on windows)
Cells are moved and shift the cells in the target area to the right or to the bottom. Source cells are emptied, except if you move within the same rows on the same sheet.
If you move within the same rows on the same sheet, the cells in the target area shift to the right, and then the whole row shifts to fill the source area.
Actual: Yes, but source cells are never emptied (not able to get this on Windows, possibly due to VMware)
Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.
Actual: Yes, but that is same behavior as without shift
Links to the source cells are inserted and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.
Actual: No, same as only option