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
Problem:
When writing values to a spreadsheet, leading zeroes are removed. They should be preserved.
Method:
<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 />
Result:
----------------------------- 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/2009Attachments:
Comments: