Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Desktop
User Name
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.


  Search this Thread
Old 09-10-2008, 01:01 AM   #1
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

Name  |   Phone  |  Zip
John  |  323-4345 |  35445
Tim  |  234-2342 | 23434
Old 09-10-2008, 01:19 AM   #2
LQ Guru
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,395

Rep: Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395Reputation: 2395
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, 07:42 AM   #3
LQ Veteran
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 416Reputation: 416Reputation: 416Reputation: 416Reputation: 416
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, 01:26 PM   #4
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


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 10:44 AM
C++ read & search in .csv files bb0330 Programming 9 03-06-2008 09:15 PM
C++ read csv file row into vector taban1 Programming 3 11-08-2004 02:01 PM
convert CSV (TEXT) files to UTF-16 cccc Programming 1 07-01-2004 01:54 AM
Shell script to read from csv file hendemeg Programming 1 05-11-2004 08:23 PM > Forums > Linux Forums > Linux - Desktop

All times are GMT -5. The time now is 05:02 PM.

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