Title:
Bug 86522:The function SpreadSheetAddRow() uses commas to delimit the values for each column in the row being added
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Julian Halliwell / Julian Halliwell (cfSimplicity)
Created: 02/28/2011
Components: Document Management, Office Integration
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,1,274733 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 5
Duplicate ID: CF-3037369
Problem:
The function SpreadSheetAddRow() uses commas to delimit the values for each column in the row being added. This means a single column value containing a comma will be treated as 2 separate column values.Enhancement request 75193 identifies the same problem but it was made and closed during the CF9 Alpha, and the issue has still not been addressed, hence this renewed request.
Method:
cfscript>mySpreadSheetObject=SpreadsheetNew( "Test" );SpreadsheetAddColumn( mySpreadSheetObject,"MySingleColumn" );MySingleColumnValue="As you can see, this sentence contains commas, which force the value to be split over 3 columns instead of one.";SpreadsheetAddRow( mySpreadSheetObject,MySingleColumnValue );sheetAsBinary=SpreadSheetReadBinary( mySpreadSheetObject );</cfscript><cfheadername="Content-Disposition"value="attachment; filename=#Chr(34)#test.xls#Chr(34)#"><cfcontent type="application/msexcel" variable="#sheetAsBinary#" reset="true">
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3043477
External Customer Info:
External Company:
External Customer Name: Julian Halliwell
External Customer Email: 2D5C74634456F5BE992016E5
External Test Config: 02/28/2011Attachments:
Comments: