Coldfusion Excel cell values 28D and 28F lost during export to excel

Asked Jul 30 '15 at 10:13

Active Jul 30 '15 at 15:09

Viewed 50 times

I am facing a weird issue with an excel export. I am exporting my products to excel using cfspreadsheet.

<cfspreadsheet action="write" filename="#theFile#" 
    overwrite="true" 
    query="DownloadProducts">

When I open excel, the columns with values 28D and 28F are replaced by just numbers like 28 and 29. The D and F alphabets are lost.

I did a cfdump and the values are correct there:

Any help is appreciated. Thank you.

edited Jul 30 '15 at 15:09

Leigh

asked Jul 30 '15 at 10:13

user3025605

1

The answer to http://stackoverflow.com/questions/15553674/cfspreadsheet-alphanumeric-values-ending-in-d explains the cause of the problem. – Dan Bracuk Jul 30 '15 at 12:52
Thanks Dan for your help! – user3025605 Jul 30 '15 at 16:10

0 Answers0