I'm using LibreOffice 220.127.116.11 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 18.104.22.168 under Debian - Set to enhancement, new - Sophie