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]