Bug 61981

Summary: DataFormatter.formatCellValue(cell) throws IllegalArgumentException when the format is ""ddd,mmm dd OR ""dddd, mmmm dd, yyyy
Product: POI Reporter: Vinay <vinaysubscribe>
Component: HSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.17-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Mac OS X 10.1   
Attachments: Sample test file with one sheet, and two cells.

Description Vinay 2018-01-09 20:18:11 UTC
Created attachment 35663 [details]
Sample test file with one sheet, and two cells.

https://issues.apache.org/jira/browse/TIKA-2196

This seems to be happening when a cell is set to custom format with double quotes, for example:

""ddd,mmm dd
or
""dddd, mmmm dd, yyyy

As per,
https://bz.apache.org/bugzilla/show_bug.cgi?id=54786

the double double quotes are replaced by a single single quote.

However in this case, there is no closing single quote.