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 <shrisource@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+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@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
Context
- Re: [libreoffice-users] Calc Major Bug (continued)
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.