Walter Hildebrandt wrote:
On Mon, Oct 5, 2009 at 2:56 AM, Andreas Saeger <[email protected]>wrote:
So we have another important hint about what you are doing acutally.
- I guess, you copy HTML-tables out of web-pages.
I have a software program that does a Data Export to my desktop. A
Microsoft Excel 97-2003 Worksheet appears on my desktop. When I open the
file with OOo I get a indication that it was a .XLS file that is now a OOo
Calc file. There are two columns. Column A has numbers and Column B has
words.
When you say "I copied from the internet", I assume that you use some
browser as "internet viewer" and that you select and copy tables out of
the browser window which may cause a lot of problems, depending on the
details of your system.
A downloaded file from the internet is a completely different story. You
download some file which is very likely an extract of some database.
The other side distributes database extracts as ".xls files" since they
assume that virtually everybody has Excel or some program to deal with
Excel files (Calc for instance).
But now you suffer from the matter of fact that your database data are
no longer in a database and spreadsheets are completely different
animals although you can do quite a few database jobs with Calc.
The most efficient database tool in Calc is the data pilot. It assumes a
list like the one you describe: One column of numnbers and another one
of text with a top row of column labels:
Value Name <-- labels
13.5 Walter
12.9 Andreas
33.1 Peter
But I still don't understand what exactly you want to extract from the 2
columns.
One thing: The ".xls"-suffix in the file name identifies the file as
something that can be used with Microsoft Excel and your Windows box
will feed that file into MS Excel if you tell it to do so (the .xls
suffix is just a label, a hint about the type of content).
Your file is not a "OOo Calc file" just because the displayed icon
indicates that currently Calc is the program to handle the file on
double-click. In fact you can feed any program with any file. If the
program can handle the file content is another question. If you have
some other xls-capable application, call something like
menu:File>Open... from that application and open the file in that other
program. The association between some type of documents and the program
to handle the contained data is not as hard-wired as some companies
would like it to be.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
