Re: [libreoffice-users] Add a Text file to Calc?

Hi,

On 01/11/2012 05:37 PM, . wrote:
> How do you add a text file to a Calc sheet?
>
> The objective I'm seeking is to be able to use Writer to create several
> paragraphs of text and then paste them into Calc.
>
> When doing so now, during the paste-in, all the text ends up in 1 cell.

One method you could try is to create a *.txt file in Writer. Then 
import the file into Calc using Insert>>Sheet from File. In the dialog 
box under Separator Options check Other and clear all the rest of the 
boxes. This will insert the text with each line being in a separate cell 
in Column A of the sheet. You must import the text before entering any 
other data into the sheet.

--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted