On Thursday 19 May 2005 12:32, Chadley Wilson wrote:
> On Thursday 19 May 2005 19: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.
> >
> > BTW, contrary to what I thought, the translation to .txt doesn't yeald a
> > better result. In case you can download/save your original file as .txt:
> >
> > 2. Loading a .txt file
> > . Open your spreadsheet
> > . choose Insert > External data, select your file and, in the drop down
> > menu ('File type'), select Text CSV; when the dialog window appears,
> > tick the small circle beside 'fixed width' in the 'separator options':
> > a graduate scale appears above the contents of you file and you can
> > manually set the column separator.
> >
> > HTH
> > Regards,
> > Ennio.
>
> What about copy and paste, If you copy data from a table in html, and past
> into OO (1.1.4) in my case, it puts every thing into the A column of the OO
> spreadsheet. I assume the original poster has the same issue?
It worked, albeit not perfectly. There were some conflicts between the
spreadsheet and the poster as to how to set out numbers.
thanks
dj tuchler
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
