Bug 61981 - DataFormatter.formatCellValue(cell) throws IllegalArgumentException when the format is ""ddd,mmm dd OR ""dddd, mmmm dd, yyyy
Summary: DataFormatter.formatCellValue(cell) throws IllegalArgumentException when the ...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC Mac OS X 10.1
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-09 20:18 UTC by Vinay
Modified: 2018-01-09 20:18 UTC (History)
0 users



Attachments
Sample test file with one sheet, and two cells. (26.00 KB, application/vnd.ms-excel)
2018-01-09 20:18 UTC, Vinay
Details

Note You need to log in before you can comment on or make changes to this bug.
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.