After 20 years of Open/LibreOffice, Calc is still missing a quick and intuitive way to move multiple lines in a spreadsheet. CTRL+V will overwrite instead of inserting, which gives especially new users a headache. In principle, "move" can be done with mouse drag&drop, but this becomes impractical in large spreadsheets, especially when the move goes past a few 1000s of lines in between. On the other hand, "paste special" is very unintuitive and also somewhat tedious. It can be done with macros, but macros aren't an option for everyone. Besides, such basic functionality ought to be present without needing to install macros. Please implement into the context menu of a selected line an option, which allows an easy and intuitive, one mouse click: "Paste lines from clipboard, above selected line, without overwriting".
Hi Eva, try holding the Alt key while moving the selected cells. Does this fix your problem?
FYI here are the options for moving cells by drag-and-drop. https://help.libreoffice.org/latest/en-US/text/scalc/guide/move_dragdrop.html
Hi Rafael, and thank you. I'm aware that lines can be moved by mouse drag&drop. It works fine for small tables. But please consider this scenario: - You have a spreadsheet with 5 tables - Each table contains 10,000 rather random looking lines - You need to make lots of manual line moves, in some cases multiple lines - Some of the moves go from one table to another In this scenario, drag&drop is not only impractical but impossible. In Microsoft Excel, easy moving of lines without mouse has always been possible: https://support.microsoft.com/en-us/office/move-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc >Select the cell, row, or column that you want to move or copy. >Do one of the following: > To move rows or columns, on the Home tab, in the Clipboard group, click Cut Button image or press CTRL+X. > To copy rows or columns, on the Home tab, in the Clipboard group, click Copy Button image or press CTRL+C. >Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following: > When you are moving rows or columns, click Insert Cut Cells. > When you are copying rows or columns, click Insert Copied Cells.</quote> I think it would be extremely useful to have this really basic functionality in Calc, too. In fact, I've always wondered why it has never been implemented!
I'll mark duplicate of this Most Annoying Bug in Calc. *** This bug has been marked as a duplicate of bug 39936 ***