Ask Your Question

Paste into spreadsheet WITHOUT separation

asked 2015-07-29 19:51:38 +0200

liblahOff gravatar image

updated 2015-08-23 23:34:50 +0200

Alex Kemp gravatar image

Calc Version: Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: en_

I need to paste some multi-line (has newline characters) text into a spreadsheet cell, but when I do it automatically separates each line into a new cell. I've tried Paste, Paste Special (selecting fixed width), Paste Special (using Separated By and entering characters NOT in the text to separate by), Paste Only (Text) option works. Clearing format of the cells doesn't work. It seems to automatically separate by newline, and there is nothing that I have seen to turn this off. Try it yourself, using the handy text below:


should not

separate these into cells

without confirming with me first

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-07-29 22:37:50 +0200

karolus gravatar image

First doubleclick into the Cell or use F2key for direkt-Input-mode then ctrl+v ....

edit flag offensive delete link more


Tested on under Debian 6.0. Works nicely.

Alex Kemp gravatar imageAlex Kemp ( 2015-07-29 23:24:44 +0200 )edit

Didn't expect it to be so simple. THX!

liblahOff gravatar imageliblahOff ( 2015-07-30 18:44:09 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2015-07-29 19:51:38 +0200

Seen: 59 times

Last updated: Jul 29 '15