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

occur exception when switching sheet with specific xlsx file

XMLWordPrintable

      reproducing steps:

      1. load the attached xlsx file "cell-border-sheet.xlsx"
        • using other files will be the same result
      2. click sheet "cell-border"
      3. occur exception

      Note that I don't know how to create another one.

      Aug 21, 2013 10:55:16 AM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1362
      SEVERE: >>java.lang.StringIndexOutOfBoundsException: String index out of range: -1
      >>	at java.lang.String.substring(String.java:1949)
      >>	at org.zkoss.zssex.model.impl.DrawingManagerImpl.getColFirstFromFormula(DrawingManagerImpl.java:222)
      >>	at org.zkoss.zssex.model.impl.DrawingManagerImpl.addComboFromFormula(DrawingManagerImpl.java:209)
      >>	at org.zkoss.zssex.model.impl.DrawingManagerImpl.initXSSFDrawings(DrawingManagerImpl.java:174)
      >>	at org.zkoss.zssex.model.impl.DrawingManagerImpl.initDrawings(DrawingManagerImpl.java:141)
      >>	at org.zkoss.zssex.model.impl.DrawingManagerImpl.getPictures(DrawingManagerImpl.java:107)
      >>	at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.preparePictureWidgets(DefaultBookWidgetLoader.java:96)
      >>	at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.onSheetSelected(DefaultBookWidgetLoader.java:87)
      >>	at org.zkoss.zss.ui.Spreadsheet.afterSheetSelected(Spreadsheet.java:4069)
      >>	at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:877)
      >>	at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:857)
      >>	at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3565)
      >>	at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87)
      >>	at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4802)
      >>	at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:708)
      >>	at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1204)
      >>	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)
      

        1. cell-border-sheet.xlsx
          42 kB
          paowang
        2. cell-border-sheet-2.xlsx
          42 kB
          paowang
        3. cell-border-sheet-3.xlsx
          44 kB
          paowang
        4. cell-border-sheet-4.xlsx
          42 kB
          paowang

            hawk hawk
            paowang paowang
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: