Status/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Peter Scarborough / Peter Scarborough (Peter Scarborough)
Created: 09/20/2016
Components: Document Management, Office Integration
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Normal / Few users will encounter
Locale/System: English(Arabic Support) / Win 2008 Server R2 64 bit
Vote Count: 0
Duplicate ID: CF-4152515
Problem Description:
According to bug report https://bugbase.adobe.com/index.cfm?event=bug&id=4152515# this was fixed issue in "CL 299842"
Is this a beta update? Where can I find it? I'm currently on build ColdFusion 11 Update 10
I have a big problem because I need to preserve leading zeros on postal codes from CSV to XLS, and:
"North Haverhill","NH",="03774","USA"
causes java.lang.ArrayIndexOutOfBoundsException error.
If I remove all the other double quotes so:
North Haverhill,NH,="03774",USA
Then I can actually get the document, however I get:
="03774"
as the actual cell value (not going to work)
="03245" is Excel standard for preserving leading zero in CSV, so this should be supported (as should just double quote wrapping all values so I don't have to check each one for commas to add or not)
-------------------------------
Steps to Reproduce:
<cfsavecontent variable="variables.excelCSV">North Haverhill,NH,="03774",USA</cfsavecontent>
<cfspreadsheet action="write" filename="\xls\testLeadingZero.xls" name="variables.excelCSV" format="csv" sheetname="sheet1" overwrite="true"/>
-------------------------------
Actual Result:
java.lang.ArrayIndexOutOfBoundsException: 4
-------------------------------
Expected Result:
Properly formatted CSV that Excel can open, would pour into XLS using cfspreadsheet
-------------------------------
Any Workarounds:
Don't use <cfspreadsheet action="write" format="csv"> and instead serve user properly formatted CSV. Not the best solution, as the point was to serve customers actual excel documents
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4191284
External Customer Info:
External Company:
External Customer Name: Peter Scarborough
External Customer Email:
External Test Config: My Hardware and Environment details:
Windows Server 2008 r2
CF11 update 10Attachments:
Comments: