Problem opening a ColdFusion created XLS in OpenOffice

I have created a cfc that you pass in queries and get back an xls with multiple worksheets. This seems to work great and opens perfectly in Microsoft Excel. However if I open it in OpenOffice I get a screen telling me it's importing text and asks me to choose the language. Then the content of the document is actually just the XML markup as plain text within two cells. Anyone ever experienced this before?

Yup, had a cfgrid that worked perfectly in CF8 and a "to spreadsheet" button below. Hitting the button created a simple excel-sheet marked up in html with minimal inline styles (cfcontent application/vnd.msexcel) opening like I expected in MSOffice. Doing the same thing with OpenOffice gave me gibberish, garbled outputs, plain html (the sourcecode) in the ODS-file. But only after having suggested how to import the text. It never was able to do what I wanted, so I ended up with a plain text-file, delimetered with #Chr(9)# and #Chr(10)# and #Chr(13)# as Linefeed. Everything has to be on one line, otherwise Open Office creates blank rows. Not very readable, manageable or otherwise useful... It functions, but for every creation I have to tell Open Office what the delimeter is... Any ideas? Sebastiaan ================================= So long and thanx 4 all the fish ==> Onlinebase.nl ----- Excess quoted text cut - see Original Post for more -----