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