Description: I'm using LO 24.2.3.2 on Mac (Ventura 13.6.6) The description of Calc/LO 6.2 states that when you move cells while holding down the Option key, the content at the insertion location shifts downward, doesn't get overwritten, and the content from the original location is transferred, not copied. Expected: a) The contents of the source cells or rows are moved and deleted at the source location. b) The content of the placement location is moved down. Result: b) existing content at the insertion location is moved down, not overwritten. OK a) the content at the original location is not deleted, the content then exists twice. I have tried all keys and combinations when releasing, the content is ALWAYS copied. Another bug in that instance: When moving entire lines, when I let go, they end up two lines ABOVE where I let go. I.e. if I grab lines 14-16 and release (Option pressed) on top of line 8, they end up ABOVE line 6. Steps to Reproduce: 1.Drag cell or line 2.release in desired place, pressing option key Actual Results: 1. cell or line is moved to new place 2. "landing" cells are moved downwards 3. content of origin cells is still in place Expected Results: 1. cell or line is moved, NOT COPIED 2. "landing" cells are moved downwards 3. origin cells are empty Reproducible: Always User Profile Reset: No Additional Info: The functionality should be restored, as described in Help https://help.libreoffice.org/6.2/de/text/scalc/guide/move_dragdrop.html?DbPAR=CALC (sorry, found that one in German, not its English counterpart) Second bug: Lines push down the line where they are released - in the case I mentioned lines 14-16, pushing down the content of line 8, not line 6.
(In reply to tymcik from comment #0) > when you move cells while holding > down the Option key, the content at the insertion location shifts downward, > doesn't get overwritten, and the content from the original location is > transferred, not copied. Instead of reading it as "...while holding down the Option key...", please try the following "tweak" to the procedure: 1. Select the desired area. 2. Click-and-hold the mouse button over (inside) the selected area. 3. While you still hold the mouse button, start dragging the mouse. 4. _Now_ press the Option key (or whichever combination of keys are needed in order to obtain the desired action/result), without releasing the mouse button yet. 5. Once the selected area is located in its desired destination, release the mouse button, and then release the Option key (or whichever other combination of keys you used). Does that work for you?