On 2011-06-20 09:19, planas wrote: > Tom > > On Sun, 2011-06-19 at 22:07 +0100, Tom Davies wrote: > > >> Hi :) >> >> 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. >> >> >> Proprietary systems do try to throw a curved ball into the mix to force >> people >> to go over to their systems for everything but Calc devs are probably able >> to >> adapt fairly easily to this particular challenge. It might help to find a >> bug-report or write one >> http://wiki.documentfoundation.org/BugReport >> Good luck and regards from >> Tom :) >> >> >> >> >> >> ________________________________ >> From: Andrew Foss <shrisou...@yahoo.ca> >> To: users@global.libreoffice.org >> Sent: Sun, 19 June, 2011 20:35:06 >> Subject: [libreoffice-users] Calc Major Bug >> >> I need to open a tab delimited text file in Calc. I have done this many >> times >> in Excel where you have to Open the File from inside Excel. However, trying >> to >> open it with Calc launches Writer (ugh!!!). It seems the programmers have >> gone >> to great lengths to stop one doing what you wants and needs to do. >> Obviously, >> if one is inside Calc, any file one tries to open should open inside Calc. >> That's a no brainer. >> >> >> How can I work around this problem? I tried tyo merge in the file but that >> also >> >> failed. I tried changing the file extension but LO ignored that. I tried >> caopy/paste into Calc but Calc failed to put each tab delimited field into >> a >> separate cell so that failed. Hopeless! >> >> Help!!!! >> >> >> -- >> 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 >> > Tab delimited files are often originally from a Word or Writer file > saved for importing into a spreadsheet. You are correct about CSV files > and spreadsheets. 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. steve
-- 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
