https://bz.apache.org/bugzilla/show_bug.cgi?id=63340

            Bug ID: 63340
           Summary: getCellType throws error on cells formatted as date
           Product: POI
           Version: 4.0.0-FINAL
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

I receive the following error when calling Cell.getCellType on cells formatted
as date. The input is an .xlsx file.

org.apache.xmlbeans.impl.values.XmlValueOutOfRangeException: string value 'd'
is not a valid enumeration value for ST_CellType in namespace
http://schemas.openxmlformats.org/spreadsheetml/2006/main
        at
org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.set_text(JavaStringEnumerationHolderEx.java:40)
        at
org.apache.xmlbeans.impl.values.XmlObjectBase.update_from_wscanon_text(XmlObjectBase.java:1180)
        at
org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated(XmlObjectBase.java:1319)
        at
org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.getEnumValue(JavaStringEnumerationHolderEx.java:60)
        at
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getT(Unknown
Source)
        at
org.apache.poi.xssf.usermodel.XSSFCell.getBaseCellType(XSSFCell.java:719)
        at
org.apache.poi.xssf.usermodel.XSSFCell.getCellType(XSSFCell.java:681)
        at
org.apache.poi.xssf.usermodel.XSSFCell.getDateCellValue(XSSFCell.java:755)

I updated to the latest 4.1 version but the error persists.

-- 
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]

Reply via email to