Created attachment 59167 [details] Screenshot of Spreadsheet after described procedure Problem description: Moving rows with drag and drop does not shift entire row Steps to reproduce: 1. Create a spreadsheet with 4 entries (e.g. "1" to "4") in row 2, 3 entries (e.g. "5" to "7") in row 3, 2 entries (e.g. "8" to "9" in row 4 and 1 entry (e.g. "10") in row 5 2. Select entire row 4 (values "8" and "9") 3. Move row 4 by drag and drop between row 2 and row 3 while pressing the "Alt" key 4. Release mouse button Current behavior: Row 3 now contains numbers "8", "9" and "7" Expected behavior: As I selected the entire row and wanted to move the entire row, I expected that the entire former row 4 would be inserted above the former row 3, i.e. that everything from row 3 downwards is shifted down and row 3 replaced by the former row 4. I expected the values "8" and "9" in row 3, and the values "5" to "7" in row 4. But the drag and drop only takes the cells from the first to the last non-empty cell, and only shifts that part of the spreadsheet down when inserting the values per drag and drop. In former versions of OpenOffice the drag and drop worked as expected (at least as I expected it and as I also know it from Excel). If I only wanted to insert certain cells I would only select those cells, but if I select the entire row I would also expect the entire row to be inserted. I also noticed that the undo operation afterwards (after I noticed this bug) then selected a different row than the row which I selected before the drag and drop operation. I also noticed that if the first column is empty I cannot move the row selection properly to the upper rows. Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0
*** This bug has been marked as a duplicate of bug 46230 ***