Title:
Bug 78913:The problem occurs when try to witre a long description value into Excel
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Akbarsait N / Akbarsait N (Akbarsait N)
Created: 07/19/2009
Components: Document Management, Office Integration
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 / 242773
Priority/Frequency: Major / Unknown
Locale/System: English / Platforms All
Vote Count: 1
Problem:
The problem occurs when try to witre a long description value into Excel.
Method:
1. Create a .cfm file.2. Copy the below content.<cfquery name="getBooks" datasource="cfbookclub">select Title, Genre, BookDescription from books</cfquery><cfset excelSheet = "#GetDirectoryFromPath(GetCurrentTemplatePath())#" & 'test.xls' /><cfset theSheet = SpreadsheetNew("CourseData") /><cfset SpreadsheetAddRow(theSheet,'Title, Genre, BookDescription') /> <cfset SpreadsheetAddRows(theSheet,getBooks) /> 3. Execute the code and look at the genarated Excel document.4. Only ascii code is displayed in the 3rd column instead of Book Description.
Result:
There is no error for this issue but the results are not displayed correctly while writing a data from Query to Excel for a value which is having long descriptive information.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039354
External Customer Info:
External Company:
External Customer Name: Akbarsait N
External Customer Email: 76AD0EA6456D42CF992015D5
External Test Config: 07/19/2009Attachments:
Comments: