Actually it's not "solved", it's I think I got the information I need: CSV file format do not support merged cells, that's when I start to look for alternative formats. Felix Miata suggested to use .wkl format which is created long before ODF and even before Excel. Kai Ponte suggested to use an opensource ODF converter for MS Office from sf.net. James Knott suggested another converter from Sun. Other people reports the sun version is easier to use. I will try both later. Carlos E. R. points out the difficulty in introducing OOO in piracy area (unfortunately, that's where I stand now, China). Thanks for understanding, but I do think there are chances to introduce OOO by my superior knowledge of OOO. E.g. I can introduce people to use DataPilot and they probably turn to OOO because of that. Meanwhile I know Excel has Pivot Data feature, which is as good or better, but I don't know how to use it, thus my users don't, thus they will prefer OOO. 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?
Best regards Zhang Weiwu
-- Real Softservice Huateng Tower, Unit 1788 Jia 302 3rd area of Jinsong, Chao Yang Tel: +86 (10) 8773 0650 ext 603 Mobile: 135 9950 2413 http://www.realss.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org