I was able to get it to open in OO.o Calc only after naming the html file spreadsheet.html.xls. The .xls extension is required or OO.o opens the file (as you saw) in it's silly HTML editor.
I couldn't get the HTML I created to work in either gnumeric or kspread. kspread looks like it just tries to import the file as a regular text file. gnumeric 1.0.4 seems to depend on some formatting in the HTML to be there before it will open and display the data. This header goofs up Excel and OO.o a little bit. The idea behind HTML is that it's a good presentation format. For those who can upload the HTML into a spreadsheet it's a dandy format for manipulation as well. For those who can't, well, at least the data can be viewed in a browser or read in plain text. It's the most cross platform solution I can think of... David -----Original Message----- From: Praedor Atrebates [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:43 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tuesday 01 April 2003 11:18 am, Anne Wilson wrote: > On Tuesday 01 Apr 2003 4:55 pm, JOHAM,DAVID (HP-Boise,ex1) wrote: > > I would suggest trying HTML. Since you're using Perl, it should be a no > > brainier to create an HTML file that you can feed to whatever your client > > is. I just tried a simple HTML file with both Excel (via CrossOver > > Office) and OpenOffice. I don't have Lotus, but I have to assume that it > > would work. Anne? > > I've never tried it, David. If you would like to send me a test html > spreadsheet I will try it and report back. David mentions he did open it fine in OpenOffice. Was that in OO write or within the OO calc? I see that gnumeric html output is opened perfectly within gnumeric (big suprise) but is not properly handled by kspread nor StarOffice 6.1 (beta) and, I would presume, 6.0. It opens the html spreadsheet in writer rather than in the spreadsheet. Excel properly imports html and places it within the spreadsheet cells? I don't have excel to play with. - -- Gods are fragile things; they may be killed by a whiff of science or a dose of common sense. -- Chapman Cohen Fingerprint: D170 2A02 B426 6AA0 5E68 3EDC 68AA FDB0 961E 4F18 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+icGfaKr9sJYeTxgRAm+4AJ9wn3t1gxFBM3lAzPNxW9HN5rwX/gCcDJov Tsr8gK2wekwQ7eAUHDChzrI= =0yFw -----END PGP SIGNATURE-----
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
