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. -- Jay Lozier jsloz...@gmail.com -- 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