tracker issue : CF-4139054

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

SpreadsheetAddRow corrupts a time value added to a spreadsheet

| View in Tracker

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 R2



Bug #CF-4139060 is NOT a duplicate of this bug. This bug is about data corruption, whereas that bug is just a formatting issue. Please reopen this bug! With this bug, when you add a value like "01:02:03" to the spreadsheet, the underlying cell content genuinely ends up with the value -1. No formatting can be applied to it to change its appearance. -1 in a cell is invalid as a date or time value in Excel.
Comment by External U.
3105 | April 19, 2016 03:02:08 PM GMT