On Thursday 19 May 2005 12:06, Ennio-Sr wrote: > * Ennio-Sr <[EMAIL PROTECTED]> [180505, 22:25]: > > * Dennis J. Tuchler <[EMAIL PROTECTED]> [180505, 10:32]: > > > 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 > > > > Hi Dennis, > > you want: Insert > External Data ...(then follow the instructions) > > for that. > > I would rather transform the .html to a .txt file first, otherwise you > > get (I suppose) all the formatting stuff of .html > > > > HTH > > Regards, > > Ennio. > > [Integrating my previous answer] > Hi Dennis, > > having similar problems I made a few tests ad hoc founding that: > 1. Loading a .html file as such: > . Open your new spreadsheet > . position cursor in a cell, say A1 > . choose Insert > External data, select your file, select the name of > the range (in the html file) to be copied, click insert: > your file will be copied in the spreadsheet, you'll see all values > perfectly alined as in the original (no formatting stuff around); > however, you'll not be able to operate on (appearing) single cells > as the range is copied as a number of rows. > Loading it as external data worked! I took the option to select all.
Tbabjs djtuchler --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
