org.zkoss.zss.ngmodel.InvalidateModelOpException: name '_FilterDatabase' 'sheet-autofilter' is dpulicated

ZK-Tracker | paowang | 3 years ago
  1. 0

    just load the attached file '''TestFile2003.xls''' {code:xml} <zk> <spreadsheet src="/TestFile2003.xls" maxVisibleRows="200" maxVisibleColumns="40" width="100%" height="100%" showContextMenu="true" showSheetbar="true" showToolbar="true" showFormulabar="true"/> </zk> {code} stack trace: {noformat} org.zkoss.zss.ngmodel.InvalidateModelOpException: name '_FilterDatabase' 'sheet-autofilter' is dpulicated at org.zkoss.zss.ngmodel.impl.BookImpl.checkLegalNameName(BookImpl.java:290) at org.zkoss.zss.ngmodel.impl.BookImpl.createName(BookImpl.java:566) at org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:166) at org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:96) at org.zkoss.zss.ngapi.impl.imexp.NExcelImportAdapter.imports(NExcelImportAdapter.java:38) at org.zkoss.zss.ngapi.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54) at org.zkoss.zss.ui.Spreadsheet.getXBook(Spreadsheet.java:616) at org.zkoss.zss.ui.Spreadsheet.getSelectedXSheet(Spreadsheet.java:790) at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4374) at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3750) at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:830) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.zkoss.zk.ui.metainfo.Property.assign0(Property.java:284) at org.zkoss.zk.ui.metainfo.Property.assign(Property.java:169) at org.zkoss.zk.ui.metainfo.ComponentInfo.applyProperties(ComponentInfo.java:729) at org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:106) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:813) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:782) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:691) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:753) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:713) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:655) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:398) 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:735) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.zss.ngmodel.InvalidateModelOpException: name '_FilterDatabase' 'sheet-autofilter' is dpulicated
  2. 0

    just load the attached file '''TestFile2003.xls''' {code:xml} <zk> <spreadsheet src="/TestFile2003.xls" maxVisibleRows="200" maxVisibleColumns="40" width="100%" height="100%" showContextMenu="true" showSheetbar="true" showToolbar="true" showFormulabar="true"/> </zk> {code} stack trace: {noformat} org.zkoss.zss.ngmodel.InvalidateModelOpException: name '_FilterDatabase' 'sheet-autofilter' is dpulicated at org.zkoss.zss.ngmodel.impl.BookImpl.checkLegalNameName(BookImpl.java:290) at org.zkoss.zss.ngmodel.impl.BookImpl.createName(BookImpl.java:566) at org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:166) at org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:96) at org.zkoss.zss.ngapi.impl.imexp.NExcelImportAdapter.imports(NExcelImportAdapter.java:38) at org.zkoss.zss.ngapi.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54) at org.zkoss.zss.ui.Spreadsheet.getXBook(Spreadsheet.java:616) at org.zkoss.zss.ui.Spreadsheet.getSelectedXSheet(Spreadsheet.java:790) at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4374) at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3750) at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:830) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.zkoss.zk.ui.metainfo.Property.assign0(Property.java:284) at org.zkoss.zk.ui.metainfo.Property.assign(Property.java:169) at org.zkoss.zk.ui.metainfo.ComponentInfo.applyProperties(ComponentInfo.java:729) at org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:106) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:813) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:782) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:691) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:753) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:713) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:655) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:398) 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:735) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.zss.ngmodel.InvalidateModelOpException: name '_FilterDatabase' 'sheet-autofilter' is dpulicated

    Root Cause Analysis

    1. org.zkoss.zss.ngmodel.InvalidateModelOpException

      name '_FilterDatabase' 'sheet-autofilter' is dpulicated

      at org.zkoss.zss.ngmodel.impl.BookImpl.checkLegalNameName()
    2. org.zkoss.zss
      Spreadsheet.setSrc
      1. org.zkoss.zss.ngmodel.impl.BookImpl.checkLegalNameName(BookImpl.java:290)
      2. org.zkoss.zss.ngmodel.impl.BookImpl.createName(BookImpl.java:566)
      3. org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:166)
      4. org.zkoss.zss.ngapi.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:96)
      5. org.zkoss.zss.ngapi.impl.imexp.NExcelImportAdapter.imports(NExcelImportAdapter.java:38)
      6. org.zkoss.zss.ngapi.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54)
      7. org.zkoss.zss.ui.Spreadsheet.getXBook(Spreadsheet.java:616)
      8. org.zkoss.zss.ui.Spreadsheet.getSelectedXSheet(Spreadsheet.java:790)
      9. org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4374)
      10. org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3750)
      11. org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:830)
      11 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. ZK Kernel
      DHtmlLayoutServlet.doGet
      1. org.zkoss.zk.ui.metainfo.Property.assign0(Property.java:284)
      2. org.zkoss.zk.ui.metainfo.Property.assign(Property.java:169)
      3. org.zkoss.zk.ui.metainfo.ComponentInfo.applyProperties(ComponentInfo.java:729)
      4. org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:106)
      5. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:813)
      6. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:782)
      7. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:691)
      8. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:753)
      9. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:713)
      10. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:655)
      11. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:398)
      12. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312)
      13. org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
      14. org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
      14 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
      2 frames
    6. Jetty
      AsyncHttpConnection.handle
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
      4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
      5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
      6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
      7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)
      8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
      9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
      10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
      11. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
      12. org.eclipse.jetty.server.Server.handle(Server.java:370)
      13. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
      14. org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949)
      15. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011)
      16. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
      17. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
      18. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
      18 frames
    7. GWT dev
      SelectChannelEndPoint$1.run
      1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668)
      2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
      2 frames
    8. Jetty
      QueuedThreadPool$3.run
      1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
      2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame