Description: In windows excel it is a very common function to copy or cut a set of rows and paste it in the excel document. Using Libreoffice calc this paste would overwrite existing information in affected rows. This is a major functionality flaw in using libreoffice calc. So I hope this paste row(s) could be mde to reflect the MS excel behaviour Insert copied cells/rows Steps to Reproduce: 1.Open an excel document using libreoffice calc (say .xslx) 2.Copy or cut a set of rows 3.Paste it somewhere in the document Actual Results: Step 3 overwrites existing cells/rows Expected Results: Insert/copied the rows as new set of rows - with no overwrite/replacement Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
Select the row, click on the select row (not in the row number) without release the mouse use [Ctrl+Alt] to copy+insert and [Shift+Alt] to move+insert.
Miguel's workaround is for mouse drag. And description looks like a duplicate of Bug 39936. *** This bug has been marked as a duplicate of bug 39936 ***