On 13/10/10 18:58, [email protected] wrote: > Mike Scott - [email protected] wrote: >> On 13/10/10 13:34, anand warik wrote: >>> Hi All, >>> >>> In spreadsheet Whenever i copy a long sentence& paste it in one cell >>> instead of having every thing in one cell itself the sentence is split& >>> pasted in number of rows. I want everything to remain in one cell. >>> Also i >> >> I can't reproduce that. However, I see that pasting multiple >> /paragraphs/ from a Writer document will make entries into several rows >> in the spreadsheet, one per paragraph. I can't find a way round that, >> even 'paste special| unformatted text' doesn't help. It doesn't seem to >> depend on the source of the text either (I tried pasting from gedit, as >> I'm using ubuntu) > > Using OOo 3.2.0 on Windows Vista... > > Press F2 to start editing the cell content, then paste into the cell. Or > click in the formula bar and paste there. Either works for me, and each > paragraph then starts a new line but still in the same cell.
Ah, thanks, I see.... I single-clicked and pasted, which results in paragraphs being split between rows. F2 == double-click == click in top entry bar, and that pastes into the one cell. Not that either helps the OP, who is apparently complaining about a "long sentence" pasting wrongly. OP - can you clarify if you still have a problem please? Perhaps give a specific example of text that won't paste as you want. -- Mike Scott Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
