tracker issue : CF-3650817

select a category, or use search below
(searches all categories and all time range)

Data Corruption

| View in Tracker

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: 
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";

<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: Coldfusion10



This bug got fixed as part of DATATYPE implementation. Now we can pass datatype of data being written and not rely on our logic to determine its datatype. This code will work now: SpreadSheetSetCellValue(WorkBook, "4D", 1, 1, 'string');
Comment by Uday O.
14189 | December 17, 2013 06:45:23 AM GMT
Adding a new parameter string to SpreadSheetSetCellValue() has fixed this issue.
Comment by HariKrishna K.
14190 | December 18, 2013 12:13:47 AM GMT