Choosing Spreadsheets does not work but CSV does if you can find it, it took some time and I doubtless would not have found it if I had not known it was there. The app should be able to tell that the Calc UI has been selected by the user which means they are trying to open a file inside a spreadsheet. If you think it could ever be otherwise, why not offer a dialog in case it looks like a Writer file?
----- Original Message ---- From: Regina Henschel <rb.hensc...@t-online.de> To: users@global.libreoffice.org Sent: Sun, June 19, 2011 3:58:46 PM Subject: Re: [libreoffice-users] Calc Major Bug Hi Andrew, Andrew Foss schrieb: > 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. That is not so obvious. Word and Excel are different programs, Word can only handle text documents and Excel can only handle spreadsheets. But LibreOffice is not a collection of 6 programs (Writer, Calc, Draw, Impress, Math, Base), but is is one program, that offers different UIs for the different tasks. Therefore a file, that looks like a text file will be opened in Writer as long as you don't determine explicitly what part to use. And a tab delimited text file contains nothing, which indicates that it is not a text file. > > > 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! (1) Inside LibreOffice use File > Open. It does not matter where you are. It might be Writer or Impress or wherever. You get a file picker dialog. (2) Select the file you want to open. (3) The dialog has a drop-down list 'file type'. Open it and scroll down to the section where are the spreadsheet formats. Choose type 'Text CSV (*.csv,*.txt)'. Open. (4) You get the import dialog. Set the needed parameters. Be careful about language, date and number formats. Kind regards Regina -- 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 -- 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
