Thanks.
As I noted in my original post, it is not that Calc WON'T display things
as I expect, it is just that I want it to do it automatically rather
than go through a specific opening process.
Thanks again.
Brian
J. Magalhães Cruz wrote:
Sorry: I forgot to mention:
My recipe works the same on both OOo 1.1.2 and 1.9.104!
José
Dizia J. Magalhães Cruz em Sexta, 17 de Junho de 2005 22:56:
Dizia Brian Speirs em Quarta, 15 de Junho de 2005 05:26:
Hi,
I would like to automatically open an html file using Calc.
I do this in Excel by giving the html file an xls extension, and Excel
does all the correct formatting.
In OOO, opening an equivalent xls file (not the same because the Excel
file includes MS xml commands) the column width formatting commands are
ignored.
If the file is opened using File -> Open and then the html filter under
Calc selected, the correct formatting is applied.
Therefore, how do I get OOO to automatically apply that html filter when
opening an xls or htm file?
Thanks,
Brian Speirs
bss59 at paradise dot net dot nz
When I want to get some data from an HTML file, in order to process it,
especially with Calc, the only way I know of doing it is by following the
steps, from OOo:
- File|Open the .html file
- Select the table or stuff you want ("Edit|Select All" can be useful)
- Edit|Copy
- File|New Spreadsheet
- Edit|Paste Special, HTML format
The layout is "reasonably" similar to the HTML's. But you can get data from
it! For example, get and process columns of data!
Hope this helps!
José
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
