[Bug 56702] New: Get one exception "java.lang.IllegalStateException: Cannot get a numeric value from a text cell" when calling org.apache.poi.ss.usermodel.DataFormatter.formatCellValue

[bugzilla]

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: dev@poi.apache.org
          Reporter: 278880...@qq.com

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: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org