LO 6.3 Calc: Move multiple rows by cutting & insert cutted cells.

edit

LO: 6.3

Suppose you have in Calc a sheet:

• with row 1 to 20 filled with data; for ease of clarity fill column A with 1 to 20 as you go with the rows.
• and desire to move rows 4 to 6 below lines 15.

Traditionnaly, in MS-Excel:

1. you select rows 4-6, then CTRL-X to cut them,
2. then on line 16 do a right-click and select the menu "insert cut cells".
3. DONE

In Calc I can:

1. I can CTRL-X the rows 4-6
2. on line 16 make a special paste with CtRL+MAJ+V
3. In the paste special menu, select the option "Shift Cells" choose option "down" and be sure that ALL other options are correct as it is a paste special.
4. then delete the empty rows 4-6

DONE

In Calc, this is way more cubbersome, no better way? Feature request for LO6.4 or later?

OF course same applies to columns

P.S. In Tools>Personnalize>Menus I haven't found any command such as "insert cut cells"