Ain Vagula wrote:
Because this format has nothing to do with Excel format and OO.o understands
this as file has no xls structure. You can open this file in calc using
right filter - File - Open, select file, then select filter: CSV text file
(.csv, .txt) and click Open.
Pure spreadsheet programs understand too, that is is simple text file but
they try to convert this to spreadsheet, because they have no word
processor. OO.o has one.
Ain,
Simple rule, "if the file is some kind of delimited text (tab, comma,
pipe, colon, whatever), calc should try and open it".
In the real world , there is *so* many tab delimited files coming from
unlimited number of systems, that the simplest way to produce a quick
spreadsheet is to use delimited text and name the file extension to the
associated spreadsheet program.
All this talk about "you must name your file .CVS or click File->Open
and go through fixing the incorrect parse wizard" is so tedious that
even Microsoft and Corel understood this nuisance and slicked things up
a bit in the spreadsheet programs. .CVS is not even an option to
associated during install-time. Just this one installation feature
could help out tremendously.
Calc really dropped the ball on this specific kind of automation.
There's been many people suffer from this same limitation. They assume
that by merely associating .xls, any file will open up in calc and ask
how to parse the text.... and I say, "fine!"
On a windows platform, the open handler should have done:
1. soffice launches
2. Notice it's filename extension and try to open the file under the
"appropriate" module, xls -> calc, .doc -> writer.
3. If actual file contents is of the proper filetype, then continue
loading. ie, the .xls is indeed a BIFF compliant Excel file.
4. If file is actually text within, don't blindly give it to writer, Let
calc *continue* to be given the opportunity to parse it.
5. Calc should sample the lines in the text file. If it is *obvisouly*
tab or comma delimited, preselect those filtered options (user just
clicks ok).
-eric wood
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
