-
Bug
-
Resolution: Fixed
-
Normal
-
2.5.0, 3.0.0 RC
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".
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)
reproducing steps
use attached file.