On 01/05/2009 03:32 AM, Dotan Cohen wrote: > I know that one can add newlines to a calc spreadsheet cell with > Ctrl-Enter, but is there a way to paste text with newlines into a calc > cell? I tried the Edit -> Paste Special menu item but it is greyed out > for some reason. > > OOo 3.0, Kubuntu 8.04
It's a bit odd, but I found that if I copy and paste a single character _from a cell in the spreadsheet_ to a new cell, then come back here copy this message text I can double-click the cell, position the cursor to the end point and paste in the text. If I try to paste the text into just a new cell it shows up as a 'text import' which means that each line gets pasted into a separate cell. Give those a try and see if you get the same. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
