Apache OpenOffice Community Forum

So I have a list of a bunch of lines of text, 20 or so lines long, each line only being a couple words. This list in in a text doc. I want to paste this into a spreadsheet document that already has data in the column I'm going to paste in. I want it so that it will paste what I want at the top, pushing down what's already there to make room. Instead, what it does is it overwrites whatever is already in the cells that my pasted list occupy. Thanks for the help!

Hi, and welcome to the forum.

stebobibo wrote:I want it so that it will paste what I want at the top, pushing down what's already there to make room.

Edit → Paste Special → Shift cells → Down → OK

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Thanks for the reply, but it doesn't work. When I try paste special it only gives me these options: open office text document, formatted text, html, unformatted text, ddd link.

It works with clipboard content from spreadsheet cells. Paste into arbitrary blank sheet cells. Then cut from there and paste-special into your list.

Thanks, that works!