Bug 149512 - Please implement intuitive way to move lines/rows
Summary: Please implement intuitive way to move lines/rows
Status: RESOLVED DUPLICATE of bug 39936
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2022-06-10 08:04 UTC by Eva
Modified: 2022-06-11 08:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Eva 2022-06-10 08:04:33 UTC
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".
Comment 1 Rafael Lima 2022-06-10 12:22:47 UTC
Hi Eva, try holding the Alt key while moving the selected cells. Does this fix your problem?
Comment 2 Rafael Lima 2022-06-10 12:59:11 UTC
FYI here are the options for moving cells by drag-and-drop.

Comment 3 Eva 2022-06-10 17:16:17 UTC
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:


>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!
Comment 4 Timur 2022-06-11 08:15:36 UTC
I'll mark duplicate of this Most Annoying Bug in Calc.

*** This bug has been marked as a duplicate of bug 39936 ***