tracker issue : CF-3040583

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

Bug 81151:When writing values to a spreadsheet, leading zeroes are removed

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Rob Kolosky / Rob Kolosky (rkolosky)

Created: 12/11/2009

Components: Document Management, Office Integration

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 9,0,0,251028 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Win All

Vote Count: 0

Duplicate ID:	CF-3039981


When writing values to a spreadsheet, leading zeroes are removed. They should be preserved.

<cfset addressQuery = queryNew("state,zipcode","varchar,varchar") /><cfset queryAddRow(addressQuery) /><cfset querySetCell(addressQuery,"state","MD") /><cfset querySetCell(addressQuery,"zipcode","21043") /><cfset queryAddRow(addressQuery) /><cfset querySetCell(addressQuery,"state","MA") /><cfset querySetCell(addressQuery,"zipcode","01748") /><cfset queryAddRow(addressQuery) /><cfset querySetCell(addressQuery,"state","RI") /><cfset querySetCell(addressQuery,"zipcode","02920") /><cfdump var="#addressQuery#" /><cfset fileName = getTempDirectory() & createUUID() & ".xls" /><cfspreadsheet action="write" filename="#fileName#" query="addressQuery" sheet="1" sheetname="Broken Zip Codes" overwrite="true" />Look at the Excel file at <cfoutput>#fileName#</cfoutput>. The zip codes for MA and RI are 4 digits instead of 5.<br />

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

Watson Bug ID:	3040583

External Customer Info:
External Company:  
External Customer Name: Rob Kolosky
External Customer Email: 0D63608F448DC27599201549
External Test Config: 12/11/2009