Open Office Calc – Pasting a Body of Text to a Cell
(This blog was written for versions of OpenOffice up to Version 3.4.0)
If you have had occasion copy a few lines of text and then paste that text into a single cell of Open Office Spreadsheet you may find the text is pasted one line at a time in a number of rows instead of all in the one cell as you wanted it to be.
One way to overcome this is to copy the lines of text, go to the Spreadsheet and click into the cell where the text is to be copied > give the space bar a single tap > then paste (Ctrl + V) The text will all be contained in the one cell.
If you are pasting to a series of cells you may find that on subsequent occasions when the space bar is tapped a highlighted body of text (the previous pasted text) will appear in the cell. Just disregard this and paste (Ctrl + V) the current body of text. This will take the place of the text that appeared highlighted in the cell.
To understand this do a trial of copy and paste.