LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices



Reply
 
Search this Thread
Old 09-10-2008, 02:01 AM   #1
ufmale
Member
 
Registered: Feb 2007
Posts: 385

Rep: Reputation: 30
OpenOffice help , read csv-like text format


I usually use Excel to open a text file with csv format where each information is separated by comman (or other delimitor). When I open the file with Excel, i will be asked what kind of delimitor i would like to apply, then Excel will display the content correctly.

However, it does not work the same for OpenOffice. It just open the file with Word prcessor (Write). Is there a way I can force OppenOffice to do the same as that of Excel.

Example of my file

Code:
Name  |   Phone  |  Zip
John  |  323-4345 |  35445
Tim  |  234-2342 | 23434
 
Old 09-10-2008, 02:19 AM   #2
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
Are you actually specifying the OO Spreadsheet prog when you do that? Otherwise, I think OO defaults to Writer, because that's the most common option.
 
Old 09-10-2008, 08:42 AM   #3
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
As far as I'm concerned this is the most annoying issue in OpenOffice....


Anyway, to open a csv file, you need to start Calc, then File->Open and in the File Type drop-down you need to select "Text-CSV" (it's about half-way through the list). It will handle other delimiters as well with the same file type.
 
Old 09-10-2008, 02:26 PM   #4
ufmale
Member
 
Registered: Feb 2007
Posts: 385

Original Poster
Rep: Reputation: 30
Thanks Hangdog42!!.. I found that option. it hide on the buttom left menu when I select the file to open
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV | Text manipulation lmedland Programming 26 07-31-2008 11:44 AM
C++ read & search in .csv files bb0330 Programming 9 03-06-2008 10:15 PM
C++ read csv file row into vector taban1 Programming 3 11-08-2004 03:01 PM
convert CSV (TEXT) files to UTF-16 cccc Programming 1 07-01-2004 02:54 AM
Shell script to read from csv file hendemeg Programming 1 05-11-2004 09:23 PM


All times are GMT -5. The time now is 04:05 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration