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

Get Exception after save and load a sheet that has comment in 2003

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.0.0 RC
    • Fix Version/s: 3.0.0 RC
    • Component/s: ZPOI, ZSS Range & Model
    • Labels:
      None

      Description

      zss doesn't support comment yet, however, If is load a 2003 xls, and just save it,
      1. if I open the file by excel, the comment is disappear.
      2. if I open the file by zss, then I get following exception

      java.lang.RuntimeException: Unexpected record type (org.zkoss.poi.hssf.record.NoteRecord)
      	at org.zkoss.poi.hssf.record.aggregates.RowRecordsAggregate.<init>(RowRecordsAggregate.java:107)
      	at org.zkoss.poi.hssf.model.InternalSheet.<init>(InternalSheet.java:216)
      	at org.zkoss.poi.hssf.model.InternalSheet.createSheet(InternalSheet.java:170)
      	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:305)
      	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:257)
      	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:201)
      	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:338)
      	at org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:319)
      	at org.zkoss.zss.model.sys.impl.HSSFBookImpl.<init>(HSSFBookImpl.java:73)
      	at org.zkoss.zss.model.sys.impl.ExcelImporter.importsFromStream(ExcelImporter.java:104)
      	at org.zkoss.zss.model.sys.impl.ExcelImporter.imports(ExcelImporter.java:73)
      	at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:51)
      	at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:71)
      	at org.zkoss.zss.app.repository.impl.SimpleRepository.load(SimpleRepository.java:59)
      	at org.zkoss.zss.app.ui.AppCtrl.doLoadBook(AppCtrl.java:305)
      	at org.zkoss.zss.app.ui.AppCtrl.doAfterCompose(AppCtrl.java:179)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.doAfterCompose(UiEngineImpl.java:533)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:835)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.createComponents(UiEngineImpl.java:1035)
      	at org.zkoss.zk.ui.impl.AbstractExecution.createComponents0(AbstractExecution.java:246)
      	at org.zkoss.zk.ui.impl.AbstractExecution.createComponents(AbstractExecution.java:238)
      	at org.zkoss.zul.Include.afterCompose(Include.java:450)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:833)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:397)
      	at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312)
      	at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
      	at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      	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.servlet.Dispatcher.forward(Dispatcher.java:327)
      	at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)
      	at org.mortbay.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:503)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      	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.headerComplete(HttpConnection.java:928)
      	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
      	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
      	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)
      

        Attachments

        1. dest.txt
          21 kB
        2. src.txt
          22 kB
        3. Test2003D.xls
          20 kB

          Activity

            People

            • Assignee:
              dennis dennis
              Reporter:
              dennis dennis
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: