tracker issue : CF-3040383

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

Bug 80605:When reading a spreadsheet containing # symbols, ColdFusion throws an eexception

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): TJ Downes / Trampas Downes (TJ Downes)

Created: 11/06/2009

Components: Language, Tags

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: 2

Problem:

When reading a spreadsheet containing # symbols, ColdFusion throws an eexception
Method:

Create an Excel spreadsheet with # symbols in the cells. Use cfspreadsheet to read the spreadsheet file


Result:

java.lang.RuntimeException: Unexpected celltype (5)

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

Watson Bug ID:	3040383

External Customer Info:
External Company:  
External Customer Name: Trampas Downes
External Customer Email: 4F362CAF4394A0B30AAC0C17
External Test Config: 11/06/2009

Attachments:

Comments:

For me this occurs for number and text fields, too.
Vote by External U.
22561 | November 11, 2011 12:39:19 AM GMT
The bug is not simply having pound signs. The bug occurs when a field with a designated format (date in my case) has an invalid value that begins with a pound sign ("#N/A" in my case). It did not error if "N/A" was in the field or "N/A#" was there. Only when the pound sign was the first character in the string. Nor did it error with other General format fields that contain pound signs.
Vote by External U.
22562 | November 11, 2011 12:39:20 AM GMT
We just had a client encounter this closed/withdrawn/cannotReproduce bug using ColdFusion 9,0,1,274733. One of the spreadsheet cells contained a value "#N/A" and ColdFusion threw an immediate "An exception occurred while using action=read. java.lang.RuntimeException: Unexpected celltype (5)" error. NOTE: My client doesn't have much control over the files they receive from a 3rd party. They are now required to search through files and manually update this value because of this ColdFusion bug.
Comment by External U.
22560 | October 01, 2015 03:52:48 PM GMT