java.lang.IllegalStateException: Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos

ZK-Tracker | benbai | 3 years ago
  1. 0

    h3. problem description: I set a conditional formatting in Excel 2007 and convert it to 2003 (xls) format. when read the 2003 test file, the exception occurs and the component is not rendered. I found that if a sheet contains "conditional formatting", the exception will be thrown. But Excel 2003 supports "conditional formatting". {code} java.lang.IllegalStateException: Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos at org.zkoss.poi.hssf.model.RecordOrderer.findDataValidationTableInsertPos(RecordOrderer.java:318) at org.zkoss.poi.hssf.model.RecordOrderer.findSheetInsertPos(RecordOrderer.java:100) at org.zkoss.poi.hssf.model.RecordOrderer.addNewSheetRecord(RecordOrderer.java:94) at org.zkoss.poi.hssf.model.InternalSheet.getOrCreateDataValidityTable(InternalSheet.java:1677) at org.zkoss.zss.model.sys.impl.HSSFSheetImpl.getDataValidations(HSSFSheetImpl.java:1113) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1677) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) at org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104) at org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56) at org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) {code} h3. reproducing steps use attached file.

    ZK-Tracker | 4 years ago | hawk
    java.lang.IllegalStateException: Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    h3. problem description: I set a conditional formatting in Excel 2007 and convert it to 2003 (xls) format. when read the 2003 test file, the exception occurs and the component is not rendered. I found that if a sheet contains "conditional formatting", the exception will be thrown. But Excel 2003 supports "conditional formatting". {code} java.lang.IllegalStateException: Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos at org.zkoss.poi.hssf.model.RecordOrderer.findDataValidationTableInsertPos(RecordOrderer.java:318) at org.zkoss.poi.hssf.model.RecordOrderer.findSheetInsertPos(RecordOrderer.java:100) at org.zkoss.poi.hssf.model.RecordOrderer.addNewSheetRecord(RecordOrderer.java:94) at org.zkoss.poi.hssf.model.InternalSheet.getOrCreateDataValidityTable(InternalSheet.java:1677) at org.zkoss.zss.model.sys.impl.HSSFSheetImpl.getDataValidations(HSSFSheetImpl.java:1113) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1677) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) at org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104) at org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56) at org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) {code} h3. reproducing steps use attached file.

    ZK-Tracker | 4 years ago | hawk
    java.lang.IllegalStateException: Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos
  4. 0

    UnknownRecord prevents to add DataValidation

    poi-user | 8 years ago | Pierre Lavignotte
    java.lang.IllegalStateException: Unexpected (org.apache.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos

    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

      Unexpected (org.zkoss.poi.hssf.record.UnknownRecord) while looking for DV Table insert pos

      at org.zkoss.poi.hssf.model.RecordOrderer.findDataValidationTableInsertPos()
    2. org.zkoss.poi
      InternalSheet.getOrCreateDataValidityTable
      1. org.zkoss.poi.hssf.model.RecordOrderer.findDataValidationTableInsertPos(RecordOrderer.java:314)
      2. org.zkoss.poi.hssf.model.RecordOrderer.findSheetInsertPos(RecordOrderer.java:100)
      3. org.zkoss.poi.hssf.model.RecordOrderer.addNewSheetRecord(RecordOrderer.java:94)
      4. org.zkoss.poi.hssf.model.InternalSheet.getOrCreateDataValidityTable(InternalSheet.java:1668)
      4 frames
    3. org.zkoss.zss
      HSSFSheetImpl.getDataValidations
      1. org.zkoss.zss.model.sys.impl.HSSFSheetImpl.getDataValidations(HSSFSheetImpl.java:1115)
      1 frame
    4. org.zkoss.zssex
      DataValidationHandlerImpl.loadDataValidtionJASON
      1. org.zkoss.zssex.ui.impl.DataValidationHandlerImpl.loadDataValidtionJASON(DataValidationHandlerImpl.java:49)
      1 frame
    5. org.zkoss.zss
      Spreadsheet.renderProperties
      1. org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1666)
      1 frame
    6. ZK Kernel
      AbstractComponent.redraw
      1. org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812)
      1 frame