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.
9

Hello @panpiper

Thank you for the reply, we appreciate your interest. I am forwarding your query to the devteam.

10

Here is working Macro for this function:

  1. Select full row copy it
  2. select row above which the copied line will be inserted
  3. run macro, as many time you like it will add a new line and fill with copied content
  4. this will not interrupt your sum sequences or formulas.

(function () {
// Get active worksheet and current selection
const ws = Api.GetActiveSheet();
if (!ws) return;

// Current selection → expand to full row (works even if only one cell is selected)
// Community examples use GetSelection() + GetEntireRow() the same way. 2
const sel = ws.GetSelection();
if (!sel) return;

const targetRow = sel.GetEntireRow();

// 1) Insert a new blank row at the selection (shift DOWN)
// This replicates Excel’s “Insert Copied Cells” insertion step. 1
targetRow.Insert(“down”);

// 2) Paste the clipboard into the newly inserted row
// Option A (recommended): PasteSpecial → paste everything (values+formats+formulas).
try {
targetRow.PasteSpecial(
“xlPasteAll”, // paste everything
“xlPasteSpecialOperationNone”,
false, // skip blanks
false // transpose
);
} catch (e) {
// Option B (fallback): sheet-level Paste to a destination range.
try {
ws.Paste(targetRow);
} catch (e2) {
// If clipboard is empty or unsupported, nothing to paste.
// You can optionally write // You can optionally write a message to a cell, log, etc.
}
}

})();

1 Like