Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Christine Ng / Christine Ng (cnguser)
Created: 10/17/2013
Components: Document Management, Office Integration
Versions: 10.0
Failure Type: Data Loss
Found In Build/Fixed In Build: Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description:cfspreadsheet can't deal with "number+D" right. When cfspreadsheet writes out the xls file, for any alphanumeric ending with "D", the "D" is missing. I've heard others mention same thing for ending with 'F".
Steps to Reproduce:
<cfscript>
Workbook = Spreadsheetnew("Workbook");
SpreadSheetSetCellValue(WorkBook, "4D", 1, 1);
// displayed 4
SpreadSheetSetCellValue(WorkBook, "4C", 1, 2);
// displayed 4C
SpreadSheetSetCellValue(WorkBook, "4E", 1, 3);
// displayed 4E
SpreadSheetSetCellValue(WorkBook, "5C", 1, 4);
// displayed 5C
SpreadSheetSetCellValue(WorkBook, "5D", 1, 5);
// displayed 5
SpreadSheetSetCellValue(WorkBook, "4d", 1, 6);
// displayed 4
MYfile = "d:\dw\dwtest\dan\abc.xls";
</cfscript>
<cfspreadsheet action="write" filename="#MYFile#" name="Workbook"
sheet=1 overwrite=true>
Actual Result: See above. "4D" becomes "4".
Expected Result: "4D"
Any Workarounds: I need your help to find it.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3650817
Deployment Phase: Release Candidate
External Customer Info:
External Company:
External Customer Name: cnguser
External Customer Email:
External Test Config: My Hardware and Environment details: Coldfusion10Attachments:
Comments: