On 2011-06-19, Steve Edmonds wrote: > On 2011-06-20 09:19, planas wrote: >> >> On Sun, 2011-06-19 at 22:07 +0100, Tom Davies wrote: >> >>> From: Andrew Foss <shrisou...@yahoo.ca> >>>> >>>> I need to open a tab delimited text file in Calc.[...] >>> >>> Where do you get the tab delimited file from? Does it offer a Csv (comma >>> separated values) option as well? If so then Csv is the more normal method >>> of >>> transferring data. >>> >> [...] CSV files will open in Calc correctly and are the more standard >> way of saving a file for a generic spreadsheet program. > > Tab delimited files are quite common. they were .tsv once. I use them > for some of my exports where the data contains commas. > The commas could be in the text of text fields or if you are using a > comma as a decimal separator you probably want a .tsv file for import. > Calc handles import of text data well in my opinion, fixed width is > usefull for undelimeted text.
Please note Calc's CSV import allows you to pick tab as a separator, thus "tab separated values" are supported, just rename the file to .csv and then pick the right option in the "Text import" window that appears. -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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