Created attachment 59315 [details] Slide deck showing examples of error in new ODS document. Problem description: Selecting a range of cells that consists of more than one column (and any number of rows), then dragging that range results in action only on the column in the range where the mouse was placed to start the drag. Steps to reproduce: 1. Select a range of cells more than one column wide. This can be done by direct selection of cells or highlighting by the row numbers. 2. Pick within those cells to perform a drag and drop. Current behavior: The graphical indication of the drag (whether using normal, ALT, CTRL, etc.) will show that it is only acting on the one column. The result when the drag and drop is executed is just the one column. Expected behavior: If selecting full rows, the entire row (all columns) should be moved, copied, overwrite, etc. (ALT, CTRL, normal, etc.). If selecting a range of cells including multiple rows and columns, all selected rows and columns should be acted upon. Additional Notes: This appears to be a problem with an ODS file that was originally created in OpenOffice 3.3. I repeated the test on a new LibreOffice 3.5.1.2 ODS file and it had a different bug. It works as expected when selecting a range of columns and rows. However, when whole rows are selected, it only acts on the columns for which data exists in those rows. If moved (ALT) to a row that has content in additional columns the content is merged (the insert only happens for the columns it selects). If the row does not have data in every column starting from the left, it will pull the object from the right to whatever column within the row was selected to start the drag/drop. Platform (if different from the browser): Windows 7 Ultimate, Service Pack 1, 64-bit. Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20100101 Firefox/11.0
Can you please check in 3.5.2 I fixed several bugs in copy/paste and DnD for 3.5.2 and this might be one of them.
The 3.5.2.2 RC appears to have resolved the behaviors I mentioned here. Full rows are moved, copied, etc. Ranges with empty leading cells no longer pull the content to the leftmost cell. There are still a couple behaviors, one directly related, one related to the Edit, Copy/Paste functions, that could use update. The related issue is, when a specific range of rows and columns are selected, you cannot move/insert (ALT) while offset by a column. You can only move/insert (ALT) such that you stay completely in the same columns, or move completely out of the selected range of columns. I'll enter a new bug report for this. I'll enter a new bug report for the Copy/Paste function as it existed in the earlier builds too. Nice that the original issues were already worked on! I'll search for reports of the other issues before posting.
*** This bug has been marked as a duplicate of bug 46230 ***