tracker issue : CF-3120738

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

cfspreadsheet not handling clobs.

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/LowImpact

Reporter/Name(from Bugbase): Mike Squire / Mike Squire (msquire11)

Created: 02/22/2012

Components: Document Management, Office Integration

Versions: 9.0

Failure Type: Incorrect w/Workaround

Found In Build/Fixed In Build: 9.0 /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 1

Problem Description: 
Clob in query becomes gibberish in spreadsheet.

Steps to Reproduce:
write a cfspreadsheet using a query containing a clob

Actual Result:
gibberish like 'C@9788973'

Expected Result:
Text like this.

Any Workarounds:
surround the clob in the select statement with a to_char function

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3120738

Deployment Phase:	Release Candidate

External Customer Info:
External Company:  
External Customer Name: msquire11
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

Not much use case. We should defer it
Comment by Uday O.
20650 | December 11, 2013 03:59:56 AM GMT
Just spent 3 hours trying to debug same problem. If you aren't going to fix it, please put a note in the help docs.
Comment by External U.
20651 | February 06, 2014 02:26:01 PM GMT
We export large amounts of data to xls reports
Vote by External U.
20652 | February 06, 2014 02:26:22 PM GMT