[Libreoffice-bugs] [Bug 136389] New: Selection drag-and-drop with Option key copying instead of shifting cells in Calc on Mac 6.4.6

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136389

            Bug ID: 136389
           Summary: Selection drag-and-drop with Option key copying
                    instead of shifting cells in Calc on Mac 6.4.6
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jdstc2 at gmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200901/f9d9aadf/attachment-0001.htm>