Bug 136389

Description:
When a selection is moved using drag-and-drop with the Option key depressed, the cells are supposed to be moved and the intervening cells shifted to accommodate it.  That is, if Row 2 is moved to below Row 4 in this way, the Row 2 data should end up in Row 4, with the old Row 3 and 4 data moved up (shifted) to Rows 2 and 3.  The result is the same number of rows, with the old selected Row 2 shifted to the new position.  This is what the help says should happen (https://help.libreoffice.org/latest/en-US/text/scalc/guide/move_dragdrop.html?DbPAR=CALC#bm_id3155686).  It is also what happens in Windows for this same 6.4.6 version.  This is the same thing Excel does when a selection is moved with the Shift key depressed.

On the Mac, the moved row is inserted and copied, with the original data left in place.  This results in adding a new row and copying the data, not moving the moved cells and shifting the intervening cells to accommodate.

I don't know if this was a problem before.  I just installed 6.4.6 today and am fairly new to using Calc on the Mac.

Steps to Reproduce:
1. Add data to a Calc spreadsheet.
2. Select a row (happens for column and range selections also).
3. Click in a data cell in the selection and drag it to a new row with the Option (Alt) key depressed.
4. Release mouse button.  Old row data is inserted and copied with old row data left in place.

e.g. Select Row 2 and move below Row 3 using this method:

A   B   C   D
1   2   3   4
a   b   c   d
w   x   y   z

Actual Results:
A   B   C   D
1   2   3   4   <= old data left in place (error) - data below should shift up.
a   b   c   d
1   2   3   4   <= row inserted and data copied here (OK)
w   x   y   z


Expected Results:
A   B   C   D
a   b   c   d
1   2   3   4  <= should be moved here and data shifted up - no change in # rows
w   x   y   z

This is what happens on the Windows version of 6.4.6.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Here's what Help says should happen:

Option Key
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.