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 > Date: Wed, 8 Sep 2010 20:21:58 -0400 > Subject: Problem opening a CF created .XLS in OpenOffice. > From: [email protected] > To: [email protected] > > > 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? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
