On Wednesday 18 May 2005 17:05, Dan Lewis wrote:
> On Wednesday 18 May 2005 12:49 pm, Dennis J. Tuchler wrote:
> > On Wednesday 18 May 2005 13:09, G. Roderick Singleton wrote:
> > > On Wed, 2005-05-18 at 10:32 -0500, Dennis J. Tuchler wrote:
> > > > I have an html document divided into rows and columns.  How can I
> > > > load it into OOO.org  as a spreadsheet for reworking?
> > > >
> > > > Thanks
> > > >
> > > > dj tuchler
> > >
> > > Off hte top of my head, I would suggest using edit > paste special
> > > but without seeing your page it is hard to know what to answer. Any
> > > chance the page can be seen publically?
> >
> > No, it's off-line now because it needs to be revised for next year
> > (it's an assignment sheet for a course I am giving).  I am surprised
> > there is no "save as" in Writer for spreadsheet format and no way of
> > importing html organized in columns and rows into the spreadsheet
> > program.  I'll try your paste special idea and see what happens.
> >
> > Thanks for the advice
> >
> > dj tuchler
>
>      Pardon me for asking a simple question. Have you tried selecting
> the entire table, copying it, opening a new spreadsheet, and pasting
> into cell A1? It might work. I am not sure what would happen if some of
> the cells in the HTML table had been split or merged. It might not make
> any difference.
>      I have tried this with 3 column 39 row table in an HTML document on
> my web site. All I had to do was to optimize the column widths.
>
It worked, imperfectly.  I had to do some formatting on the new Calc product. 
Still, it worked.  Thanks for your help!

dj tuchler

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to