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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
