Re: HTML encoded spreadsheets?

[David Stanaway <david stanaway net>]

On Thu, 2005-09-08 at 10:29 -0400, Jody Goldberg wrote:
> On Wed, Sep 07, 2005 at 11:05:49PM -0500, David Stanaway wrote:
> > On Wed, 2005-09-07 at 18:40 -0600, Andreas J. Guelzow wrote:
> > > On Wed, 2005-07-09 at 18:06 -0500, David Stanaway wrote:
> > > > Also, when I open with the html format module, lots of errors scroll
> > > > about namespace errors. It is an html file with excel xml markup eg:
> > > >
> > > > EG:
> > > >
> > > >   <td class=xl29 width=71
> > > > style='border-top:none;border-left:none;width:53pt'
> > > >   x:num>880</td>
> > > >
> > > > x:num flags an error
> > >
> > > I really think that x:num is not acceptable in a td tag in any version
> > > of html. 
> >
> > I agree it is not html, but it is I assume covered in the
> > xmlns:x="urn:schemas-microsoft-com:office:excel" namespace. (This I do
> > not expect to be supported by the html module, except by specific design
> > of course)
>
> It sounds like this needs to be treated as a special XL specific
> format, probably in the xls plugin which does have a probe routine.
> We can have a look during 1.7.  We need to make up std test file
> with things like
>      - formating
>       : alignments
>       : borders
>       : font/back/pattern colours
>      - merged cells
>      - array formulas

Here is a hand edited sample.  The image might be a bit screwy, but
commendably, gnumeric elects not to load images from remote urls, so I
imagine this would be the ? collage graphic in gnumeric anyway.

9/2/2005
** Green highlight represents data of very high interest
** Note: This is a test
Please take with a grain of salt
Company	Part Name	Part ID	Mult	1st	Add	Effective Date	Comments
Company	Machine code debugger	P4.43.21	1.0	30	6	7/29/2005	No Change
Company	Phased Array mount 2.4 GHz	P.2.34	1.0	60	60	6/13/2005	No Change
Company	Cable Cat 5e	c5e.50m	1.0	60	60	9/8/2005	Increase