On Tuesday 11 December 2007 05:05, Zhang Weiwu wrote: > Dear all, this is OT but I am not sure where to ask about it: > > Usually when we work on web applications and offer user some > spreadsheets for downloading, my primary choice is CSV format. This is > because both Excel and OpenOffice users can open it. Now we need to > generate spreadsheet from the web application that has merged cells in it. > > This time CSV format doesn't work, it cannot represent merged cells. > > I prefer not to create Excel formats because I don't wish to encourage > use of Excel format. I cannot use ODF because no one can open it (people > use things like Excel 2003). PDF also doesn't work because we need to > allow users to do some calculation based on table sell data. Is there > another format I can offer?
Never treid this but I'd heard good things... http://sourceforge.net/projects/odf-converter ...in this manner your customers can open ODF files from within MS Office. I'll give it a shot today when I go to work to see what it does in Office 2003.
test_excel.ods
Description: application/vnd.oasis.opendocument.spreadsheet