Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-408

Cannot save 2003 format if the file contains auto filter configuration.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.0.0 RC
    • 3.0.0 RC
    • ZPOI
    • None

      auto filter is not supported in 2003, however, If the file contains autofilter (create by excel). then I cann't save it.
      get exception when save this file.

      : >>java.lang.IllegalStateException: Error in serialization of (org.zkoss.poi.hssf.record.AutoFilterRecord): Incorrect number of bytes written - expected 35 but got 6
      >>	at org.zkoss.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:50)
      >>	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1281)
      >>	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1327)
      >>	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1227)
      >>	at org.zkoss.zss.model.sys.impl.ExcelExporter.export(ExcelExporter.java:35)
      >>	at org.zkoss.zss.api.impl.ExporterImpl.export(ExporterImpl.java:48)
      >>	at org.zkoss.zss.app.repository.impl.SimpleRepository.save(SimpleRepository.java:71)
      >>	at org.zkoss.zss.app.repository.impl.SimpleRepository.saveAs(SimpleRepository.java:101)
      >>	at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:283)
      >>	at org.zkoss.zss.app.ui.AppCtrl$7.onEvent(AppCtrl.java:1)
      >>	at org.zkoss.zss.app.ui.dlg.DlgCtrlBase$1.onEvent(DlgCtrlBase.java:57)
      >>	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)
      

            dennis dennis
            dennis dennis
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: