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?
--
Chadley Wilson
Redhat Certified Technician
Cert Number: 603004708291270
Pinnacle Micro
Manufacturers of Proline Computers
====================================
Exercise freedom, Use LINUX
=====================================
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
