That sound like you want to link to external data. This is an Insert
option. See Help and/or http://documentation.openoffice.org/
On Sat, 2005-06-18 at 14:59 +1200, Brian Speirs wrote:
> 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]
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
