java.lang.IllegalStateException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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.
    via by hawk,
  • 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.
    via by hawk,
    • 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)
    No Bugmate found.