On Wed, 18 May 2005, Ennio-Sr wrote:
> * 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?
>
> 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
I didn't get any HTML formatting when I tried it but
something interesting happened.
Most of the cells contain text like this:
1-2
10-15
8-11
etc.
Somehow, these get interpreted as DATES and there's no way
to reform them back!
(My workaround was to change all the dashes to the
character string " vs. " and then everything worked fine.)
---
Pete Holsberg
Columbus, NJ
---
Do not anticipate trouble, or worry about what may never
happen. Keep in the sunlight.
Benjamin Franklin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]