Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Paste into spreadsheet WITHOUT separation

Calc Version: 4.4.1.2 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)...no 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:

LibreOffice

should not

separate these into cells

without confirming with me first

Paste into spreadsheet WITHOUT separation

Calc Version: 4.4.1.2 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)...no 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:

LibreOffice

should not

separate these into cells

without confirming with me first