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é
--
J. Magalhães Cruz --- [EMAIL PROTECTED] ---
... free, as in freedom... (Richard Stallman)
... private, as in personal... (jmcruz)
... respect, to all animals... (jmcruz)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
