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

ZK-Tracker | benbai | 3 years 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

    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

    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