Bug 74403 - EDITING: Drag-and-drop rows with Alt or Ctrl+Alt could allow better set of destination rows
Summary: EDITING: Drag-and-drop rows with Alt or Ctrl+Alt could allow better set of de...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
Reported: 2014-02-02 18:13 UTC by dg1727
Modified: 2019-02-20 18:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description dg1727 2014-02-02 18:13:50 UTC
I'm using LibreOffice on Ubuntu 13.04.  

1.  Create a new document in Calc.  
2.  In column A, put distinct values in cells 1-3.  The autofill handle can be used for this (e.g., put the value 1 in cell A1 and drag the autofill handle down to produce 1, 2, 3).  
3.  Click the row label for row 2 to select the row.  
4.  Start dragging a cell within that row.  
5.  Hold down Alt to select "move & insert."  The outline of the row being dragged will change to have a thin border on the bottom but still a thick border on top.  The thick border indicates where the dragged row will be inserted if the mouse button is released.  
6.  If you mouse over row 2 to attempt to move-&-insert between rows 1 & 2, the mouse pointer will change to a "no drop" symbol (a circle-slash in some icon themes) to indicate that it's meaningless to move-&-insert the row over itself (no change in the spreadsheet would result).  This seems correct.  

7.  Shouldn't the no-drop symbol also appear when the user mouses over row 3, to move-&-insert row 2 between rows 2 & 3?  Currently, dropping the row between rows 2 & 3 is allowed, but doesn't change the spreadsheet.  


8.  In step 5, use Ctrl+Alt to select "copy & insert."  
9.  This time, inserting between rows 2 & 3 (step 7) does something - if the rows in column A contained 1, 2, 3, then after the copy-&-insert, they contain the values 1, 2, 2, 3.  This seems correct.  

10.  Shouldn't it be possible to copy-&-insert between rows 1 & 2 (step 6)?  This would have the same effect as in step 9 (the values 1, 2, 2, 3).  But currently, the mouse pointer changes to a "no drop" symbol over row 2.  

Similar issues probably affect the other variations of move-&-insert and copy-&-insert (whole columns and also ranges that are less than a whole column or row).
Comment 1 sophie 2014-02-13 14:29:16 UTC
Reproduced with under Debian - Set to enhancement, new - Sophie