Add a Text file to Calc?

classic Classic list List threaded Threaded
4 messages Options
PDA1 PDA1
Reply | Threaded
Open this post in threaded view
|

Add a Text file to Calc?

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.

--
For unsubscribe instructions e-mail to: [hidden email]
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

Jay Lozier Jay Lozier
Reply | Threaded
Open this post in threaded view
|

Re: 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
[hidden email]


--
For unsubscribe instructions e-mail to: [hidden email]
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

Jack Jack
Reply | Threaded
Open this post in threaded view
|

Re: Add a Text file to Calc?

Jay Lozier wrote:
> On 01/11/2012 05:37 PM, . wrote:
>> How do you add a text file to a Calc sheet?
>>
> One method you could try is to create a *.txt file in Writer. Then import
> the file into Calc using Insert>>Sheet from File.
> [snip]

Something else you could also try is using Paste Special.  In Writer,
write some text.  Then select the text you want to insert into Calc
and *copy* it (right click -> copy, or Ctrl + c).  Then go to Calc and
*paste special* (right click -> paste special... or Ctrl + Shift + v).
 I just tried the first of the listed options (LibreOffice 3.4 Text
Document) which seems to do the job, but you're welcome to experiment
with different options.

Regards
Stephan

--
For unsubscribe instructions e-mail to: [hidden email]
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

PDA1 PDA1
Reply | Threaded
Open this post in threaded view
|

Re: Add a Text file to Calc?



On 01/12/2012 02:19 AM, Stephan Zietsman wrote:

> Jay Lozier wrote:
>> On 01/11/2012 05:37 PM, . wrote:
>>> How do you add a text file to a Calc sheet?
>>>
>> One method you could try is to create a *.txt file in Writer. Then import
>> the file into Calc using Insert>>Sheet from File.
>> [snip]
> Something else you could also try is using Paste Special.  In Writer,
> write some text.  Then select the text you want to insert into Calc
> and *copy* it (right click -> copy, or Ctrl + c).  Then go to Calc and
> *paste special* (right click -> paste special... or Ctrl + Shift + v).
>  I just tried the first of the listed options (LibreOffice 3.4 Text
> Document) which seems to do the job, but you're welcome to experiment
> with different options.
>
> Regards
> Stephan

Man, I'm so dumb it drives me nuts!  The only option I hadn't tried was
"paste in Libreoffice document".
2 pages were pasted in and then the resulting frame holder was dragged
to make it large enough to show all of the text.

Thank you for the help!


>


--
For unsubscribe instructions e-mail to: [hidden email]
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