I'm using LibreOffice 4.1.4.2 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).
Reproduced with 4.1.5.3 under Debian - Set to enhancement, new - Sophie