Status/Resolution/Reason: Closed/Fixed/Fixed
Reporter/Name(from Bugbase): Legorol San / Legorol San (Legorol San)
Created: 04/12/2016
Components: Document Management, Office Integration
Versions: 10.0
Failure Type: Data Corruption
Found In Build/Fixed In Build: Final / 10,0,23,302222
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win All
Vote Count: 0
Duplicate ID: CF-4139060
Problem Description: When using SpreadsheetAddRow to add a value that looks like a time, the value is corrupted.
Steps to Reproduce:
<cfset st = SpreadSheetNew("Here")>
<cfset SpreadSheetAddRow(st, "01:02:03")>
<cfdump var=#SpreadsheetGetCellValue(st,1,1)#><br>
<cfspreadsheet action="write" filename="out.xls" name="st" overwrite="true">
Actual Result:
cfdump gives -1. Cell A1 in out.xls contains -1 and has strange formatting applied.
Expected Result:
cfdump should give 01:02:03 or possibly a variant such as 1:02:03 or 1:02:03 AM.
Cell A1 in out.xls should contain a date value with a proper time format applied.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4139054
Reason: BugReVerified
External Customer Info:
External Company:
External Customer Name: Legorol San
External Customer Email:
External Test Config: My Hardware and Environment details: Windows Server 2008 R2Attachments:
Comments: