Feature request - Spreadsheet - possibility to insert copied lines

Desktop editors
1

In MS Excel, you have a feature that is great for improving your productivity: if you copy one or several lines, you can right-click a line number where you want to insert a copy of the lines, and then choose “insert the copied lines”.
New lines are at once created and filled with copied content.
This would be a great feature to have in OO.
Thanks.

2

Hello @arcqus

Almost the same scenario works for Desktop Editors, but only instead of Insert the Copied Lines you use Paste:
2023-03-07 11-23-13

Please elaborate if I’m misunderstanding something.

3

hi @Constantine
Please check what I have in mind (no need to specify where it’s from :slight_smile: :
firefox_KDnEyDDDY4

4

Thank you very much for clarification.
This suggestion is registered in our internal tracker under the number 46275. This feature will be implemented in one of the future releases.

6

A small question : when you say it is registered, was it already in there or you added it ?
Thanks.

7

In this particular case it was already registered in our system.

8

I have to admit I obsessed over this very issue for a good minute. What you have to do is:

  1. Highlight the rows you want to insert from the rows header with mouse clicks and/or Shift.
  2. Move the mouse cursor over any of the highlighted headers to prompt the “drag and drop” feature…the cursor becomes a little hand.
  3. While pressing Shift, click and hold the mouse button. Once the clock activated the “grab” feature you can let go of the shift key.
  4. Drag the most cursor to the header of the last row you want to be on top of the new rows you will be creating.
  5. Finally, “drop” the dragged content. The rows will automatically shift down the existing data and insert the dragged context accordingly.
  6. Delete the old rows of needed as this only copies and doesn’t cut.
  7. Please add any relevant clarifications or tips if you know of any. This is an essential feature that is actually quite easy to use but hard to understand when switching from MS.
  • It appear that the highlighted rows have to be adjoining, so this method won’t work with Ctrl clicking individual random rows. You can tell because the drag and drop “grab/click” will only fully highlight the rows immediately connected to the selected row header… the stragglers will remain selected but only as a reference through marching ant borders.