org.zkoss.zss.model.InvalidModelOpException: name '_dif6' is dpulicated

ZK-Tracker | kolodz | 2 years ago
  1. 0

    When the attachment file (of this issue) is load with : <spreadsheet src="POC_Sopra.xlsx" width="1000px" height="1000px" showSheetbar="true" showToolbar="true" showFormulabar="true" maxVisibleRows="200" maxVisibleColumns="40"/> It's trigger this error : HTTP ERROR 500 Problem accessing /tab_tableur.zul. Reason: Server Error Caused by: org.zkoss.zss.model.InvalidModelOpException: name '_dif6' is dpulicated at org.zkoss.zss.model.impl.BookImpl.checkLegalNameName(BookImpl.java:277) at org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:574) at org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:570) at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:162) at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:97) at org.zkoss.zss.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:40) at org.zkoss.zss.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54) at org.zkoss.zss.ui.Spreadsheet.getSBook(Spreadsheet.java:606) at org.zkoss.zss.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:800) at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4376) at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3752) at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:840) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:857) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:872) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:442) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:356) 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) 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.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) 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:494) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033) 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:667) 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:744) Powered by Jetty://

    ZK-Tracker | 2 years ago | kolodz
    org.zkoss.zss.model.InvalidModelOpException: name '_dif6' is dpulicated
  2. 0

    When the attachment file (of this issue) is load with : <spreadsheet src="POC_Sopra.xlsx" width="1000px" height="1000px" showSheetbar="true" showToolbar="true" showFormulabar="true" maxVisibleRows="200" maxVisibleColumns="40"/> It's trigger this error : HTTP ERROR 500 Problem accessing /tab_tableur.zul. Reason: Server Error Caused by: org.zkoss.zss.model.InvalidModelOpException: name '_dif6' is dpulicated at org.zkoss.zss.model.impl.BookImpl.checkLegalNameName(BookImpl.java:277) at org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:574) at org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:570) at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:162) at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:97) at org.zkoss.zss.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:40) at org.zkoss.zss.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54) at org.zkoss.zss.ui.Spreadsheet.getSBook(Spreadsheet.java:606) at org.zkoss.zss.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:800) at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4376) at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3752) at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:840) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:857) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:872) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:442) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:356) 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 javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) 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.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) 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:494) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033) 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:667) 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:744) Powered by Jetty://

    ZK-Tracker | 2 years ago | kolodz
    org.zkoss.zss.model.InvalidModelOpException: name '_dif6' is dpulicated

    Root Cause Analysis

    1. org.zkoss.zss.model.InvalidModelOpException

      name '_dif6' is dpulicated

      at org.zkoss.zss.model.impl.BookImpl.checkLegalNameName()
    2. org.zkoss.zss
      Spreadsheet.setSrc
      1. org.zkoss.zss.model.impl.BookImpl.checkLegalNameName(BookImpl.java:277)
      2. org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:574)
      3. org.zkoss.zss.model.impl.BookImpl.createName(BookImpl.java:570)
      4. org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.importNamedRange(AbstractExcelImporter.java:162)
      5. org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:97)
      6. org.zkoss.zss.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:40)
      7. org.zkoss.zss.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54)
      8. org.zkoss.zss.ui.Spreadsheet.getSBook(Spreadsheet.java:606)
      9. org.zkoss.zss.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:800)
      10. org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4376)
      11. org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3752)
      12. org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:840)
      12 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      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:857)
      6. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826)
      7. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735)
      8. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699)
      9. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:872)
      10. org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:826)
      11. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:735)
      12. org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:699)
      13. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:442)
      14. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:356)
      15. org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
      16. org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
      16 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
      3. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
      3 frames
    6. Jetty
      AsyncHttpConnection.handle
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
      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.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
      12. org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
      13. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
      14. org.eclipse.jetty.server.Server.handle(Server.java:370)
      15. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
      16. org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)
      17. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)
      18. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
      19. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
      20. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
      20 frames
    7. GWT dev
      SelectChannelEndPoint$1.run
      1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)
      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:744)
      1 frame