Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Problem opening a ColdFusion created XLS in OpenOffice
Author: Sebastiaan GMC van Dijk
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:61900#336929
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 -----
Author: Michael Grant
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:61900#336924
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?
|
May 24, 2012
|
Latest Fusion Authority Articles
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
