java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC formula cell

apache.org | 3 weeks ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    POI regression testing report

    apache.org | 3 weeks ago
    java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC formula cell

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Cannot get a STRING value from a NUMERIC formula cell

      at o.a.p.xssf.usermodel.XSSFCell.typeMismatch()
    2. o.a.p
      XSSFFileHandler.handleFile
      1. o.a.p.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1062)
      2. o.a.p.xssf.usermodel.XSSFCell.checkFormulaCachedValueType(XSSFCell.java:403)
      3. o.a.p.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:391)
      4. o.a.p.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:347)
      5. o.a.p.xssf.usermodel.XSSFTable.updateHeaders(XSSFTable.java:359)
      6. o.a.p.xssf.usermodel.XSSFTable.writeTo(XSSFTable.java:93)
      7. o.a.p.xssf.usermodel.XSSFTable.commit(XSSFTable.java:104)
      8. o.a.p.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:414)
      9. o.a.p.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:419)
      10. o.a.p.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:419)
      11. o.a.p.POIXMLDocument.write(POIXMLDocument.java:242)
      12. o.a.p.stress.SpreadsheetHandler.writeToArray(SpreadsheetHandler.java:70)
      13. o.a.p.stress.SpreadsheetHandler.handleWorkbook(SpreadsheetHandler.java:41)
      14. o.a.p.stress.XSSFFileHandler.handleFile(XSSFFileHandler.java:62)
      14 frames
    3. org.dstadler.commoncrawl
      FileHandlingRunnable.run
      1. org.dstadler.commoncrawl.FileHandlingRunnable.run(FileHandlingRunnable.java:64)
      1 frame