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?
The HTML worked great with one caveat. OpenOffice has a web authoring "feature" that thinks it knows better than I do what app to open when I ask it to load HTML files. Thus, if you call your spreadsheet "spreadsheetdata.html", OpenOffice will happily open the HTML in it's web editor. I could not figure out how to stop that behavior without some serious tweaking in OpenOffice's configuration. The only way I found (in admittedly about 2 minutes of trying) to work around this problem was to call the HTML file spreadsheetdata.html.xls. That way, OpenOffice "thinks" it's a spreadsheet and opens it in the right application. I choose to keep the HTML part just so that folks know it's really HTML and not binary Excel data. Hope this helps! David -----Original Message----- From: Frankie [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 7:11 AM To: [EMAIL PROTECTED] Subject: [expert] open source spreadsheet file format. Hi guys, I have to write a webapp with a downlaod option for the data.. at present the format is in .csv (comma seperated values) however there are massive limitations to what csv can display. notably there is no way to make headers of format the data at all In word processors we have rich text format (.rtf) is there anything available that does the same thing for spreadsheets? It must be openable in excel, lotus etc.. and hopefully openoffice as well... Does anyone have any suggestions on this one?? regards Franki
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com