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

ZK-Tracker | hawk | 4 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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. 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
  3. Speed up your debug routine!

    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:318)
      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:1677)
      4 frames
    3. org.zkoss.zss
      Spreadsheet.renderProperties
      1. org.zkoss.zss.model.sys.impl.HSSFSheetImpl.getDataValidations(HSSFSheetImpl.java:1113)
      2. org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1677)
      2 frames
    4. ZK Kernel
      HtmlPageRenders.outPageContent
      1. org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812)
      2. org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614)
      2 frames
    5. ZK XUL Components
      PageRenderer.render
      1. org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104)
      2. org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56)
      2 frames
    6. ZK Kernel
      DHtmlLayoutServlet.doGet
      1. org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856)
      2. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497)
      3. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316)
      4. org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
      5. org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
      5 frames