reproducing steps:
1. load a xlsx file with autofilter
2. export once (no any modification)
3. select one column with autofilter
4. insert/delete one column on selected column
5. occur exception
Aug 21, 2013 11:03:06 AM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1362 SEVERE: >>java.lang.IndexOutOfBoundsException >> at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTWorksheetImpl.getColsArray(Unknown Source) >> at org.zkoss.poi.xssf.usermodel.helpers.ColumnHelper.getOrCreateColumn1Based(ColumnHelper.java:259) >> at org.zkoss.poi.xssf.usermodel.helpers.ColumnHelper.setColWidth(ColumnHelper.java:243) >> at org.zkoss.poi.xssf.usermodel.XSSFSheet.setColumnWidth(XSSFSheet.java:2080) >> at org.zkoss.zss.model.sys.impl.XSSFSheetImpl.shiftColumnsOnly(XSSFSheetImpl.java:681) >> at org.zkoss.zss.model.sys.impl.BookHelper.insertXSSFColumns(BookHelper.java:2224) >> at org.zkoss.zss.model.sys.impl.BookHelper.insertColumns(BookHelper.java:2201) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.insert(XRangeImpl.java:741) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.insert(XRangeImpl.java:747) >> at org.zkoss.zss.api.impl.RangeImpl.insert(RangeImpl.java:470) >> at org.zkoss.zss.api.CellOperationUtil.insert(CellOperationUtil.java:729) >> at org.zkoss.zss.ui.impl.undo.InsertCellAction.doAction(InsertCellAction.java:54) >> at org.zkoss.zssex.ui.impl.UndoableActionManagerImpl.doAction(UndoableActionManagerImpl.java:50) >> at org.zkoss.zss.ui.impl.ua.InsertColumnHandler.processAction(InsertColumnHandler.java:52) >> at org.zkoss.zss.ui.impl.ua.AbstractHandler.process(AbstractHandler.java:58) >> at org.zkoss.zss.ui.impl.DefaultUserActionManagerCtrl.dispatchAuxAction(DefaultUserActionManagerCtrl.java:272) >> at org.zkoss.zss.ui.impl.DefaultUserActionManagerCtrl.onEvent(DefaultUserActionManagerCtrl.java:395) >> at org.zkoss.zssex.ui.impl.UserActionManagerCtrlImpl.onEvent(UserActionManagerCtrlImpl.java:285) >> at org.zkoss.zss.ui.Spreadsheet$3.onEvent(Spreadsheet.java:386) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) >> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) >> at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) >> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) >> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) >> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
- blocks
-
ZSS-437 load a empty sheet and export it then call Range API to setColumnWidth on any range will throw exception.
- Closed