OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Is there a way to import a txt file into Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
charliegrigg
Newbie
Newbie


Joined: 25 Apr 2008
Posts: 2

PostPosted: Fri Apr 25, 2008 4:06 pm    Post subject: Is there a way to import a txt file into Calc Reply with quote

In Excel you can import a txt file so that it opens as a spreadsheet. It asks you where you want the column breaks ect.
Everytime I try this in Calc, it opens up the world processor!
How can I do this import?
I am new to this posting stuff, so excuse me if I an not doing it correctly!
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Apr 25, 2008 5:55 pm    Post subject: Reply with quote

Try renaming the file as "filename.CSV" instead of "filename.txt".

David.
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Fri Apr 25, 2008 10:56 pm    Post subject: Re: Is there a way to import a txt file into Calc Reply with quote

charliegrigg wrote:
How can I do this import?

Call "File" > "Open..." and use the appropriate File type "TextCSV (*.csv;*.txt;*.xls)" from the list.
Back to top
View user's profile Send private message
charliegrigg
Newbie
Newbie


Joined: 25 Apr 2008
Posts: 2

PostPosted: Mon Apr 28, 2008 7:07 am    Post subject: Reply with quote

Changing it to a CSV file worked! Thank you.

Using open, and selecting the txt file type did not work, it still opened up the Writer.

Thanks to both of you for your suggestions!
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Tue Apr 29, 2008 12:28 pm    Post subject: Reply with quote

charliegrigg wrote:
Using open, and selecting the txt file type did not work, it still opened up the Writer.

I suggested the usage of the File type "Text CSV (*.csv;*.txt;*.xls)" (which opens in OOo Calc, because it is an OOo Calc Import Filter) and not the File type "Text (*.txt)" (which opens in OOo Writer, because it is an OOo Writer Import Filter).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group