Re: [libreoffice-users] Calc Major Bug

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.henschel@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+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

-- 
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