https://issues.apache.org/bugzilla/show_bug.cgi?id=56702
Bug ID: 56702
Summary: Get one exception "java.lang.IllegalStateException:
Cannot get a numeric value from a text cell" when
calling
org.apache.poi.ss.usermodel.DataFormatter.formatCellVa
lue
Product: POI
Version: 3.8
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
There in one cell which value is empty string instead of null cell.
I got the exception
Caused by: java.lang.IllegalStateException: Cannot get a numeric value from a
text cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
at
org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:202)
at
org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(DateUtil.java:325)
at
org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(DataFormatter.java:756)
Also, I debugged source code and found that the cell type is CELL_TYPE_NUMERIC,
so when it convert to double, the exception will be thrown.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
