Ask Your Question

How to paste between cells and preserve value [closed]

asked 2018-04-13 13:18:04 +0100

libtai gravatar image

updated 2018-04-13 13:22:16 +0100

Hi, I have the following issue in Calc:

Sheet with values in cells A1 and A3.

I select cell A2 and paste some delimited text which I copied from outside Calc.

The value in cell A3 is overwritten by the pasted content.

Is there a way to paste at some cell having cell values on the next row shift down? Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-04-16 14:26:28.532277


The value in cell A3 is overwritten by the pasted content. How did you accomplish this? I tried pasting "a,b,c" from a text editor into cell A2 but it does not overwrite cell A3.

Jim K gravatar imageJim K ( 2018-04-13 17:43:09 +0100 )edit

Happens when the clipboard contains multi-line text.

erAck gravatar imageerAck ( 2018-04-13 19:41:40 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-04-13 19:51:59 +0100

erAck gravatar image

Clipboard paste overwrites and does not insert rows/columns/cells, unless it is the Calc internal clipboard and Paste Special is used, which offers to shift cells. To insert between cells shifting those, best paste the external data onto an empty area and then copy that area and Paste Special to the final destination with Shift Cells Down activated.

edit flag offensive delete link more


Thanks @erAck! This is exactly what I was looking for :)

libtai gravatar imagelibtai ( 2018-04-14 12:57:01 +0100 )edit

Question Tools

1 follower


Asked: 2018-04-13 13:18:04 +0100

Seen: 96 times

Last updated: Apr 13 '18