java.lang.RuntimeException: Zero length string is an invalid sheet name

ZK-Tracker | paowang | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    reproduce steps: # load attached file # delete sheet "row" # goto sheet "cell-reference" # cause exception * cannot delete sheet "cell-data" {noformat} SEVERE: >>java.lang.RuntimeException: Zero length string is an invalid sheet name >> at org.zkoss.poi.ss.formula.SheetNameFormatter.needsDelimiting(SheetNameFormatter.java:102) >> at org.zkoss.poi.ss.formula.SheetNameFormatter.appendFormat(SheetNameFormatter.java:61) >> at org.zkoss.poi.ss.formula.ptg.ExternSheetNameResolver.prependSheetName(ExternSheetNameResolver.java:44) >> at org.zkoss.poi.ss.formula.ptg.Ref3DPtg.toFormulaString(Ref3DPtg.java:91) >> at org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92) >> at org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83) >> at org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624) >> at org.zkoss.zss.model.sys.impl.BookHelper.getEditText(BookHelper.java:1132) >> at org.zkoss.zss.model.sys.impl.BookHelper.getRichEditText(BookHelper.java:1197) >> at org.zkoss.zss.ui.impl.XUtils.getRichEditText(XUtils.java:360) >> at org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:351) >> at org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:81) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3251) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086) >> at org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1691) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:933) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:879) >> at org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:862) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3678) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4941) >> 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:601) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) >> 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) {noformat}

    ZK-Tracker | 3 years ago | paowang
    java.lang.RuntimeException: Zero length string is an invalid sheet name
  2. 0

    reproduce steps: # load attached file # delete sheet "row" # goto sheet "cell-reference" # cause exception * cannot delete sheet "cell-data" {noformat} SEVERE: >>java.lang.RuntimeException: Zero length string is an invalid sheet name >> at org.zkoss.poi.ss.formula.SheetNameFormatter.needsDelimiting(SheetNameFormatter.java:102) >> at org.zkoss.poi.ss.formula.SheetNameFormatter.appendFormat(SheetNameFormatter.java:61) >> at org.zkoss.poi.ss.formula.ptg.ExternSheetNameResolver.prependSheetName(ExternSheetNameResolver.java:44) >> at org.zkoss.poi.ss.formula.ptg.Ref3DPtg.toFormulaString(Ref3DPtg.java:91) >> at org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92) >> at org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83) >> at org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624) >> at org.zkoss.zss.model.sys.impl.BookHelper.getEditText(BookHelper.java:1132) >> at org.zkoss.zss.model.sys.impl.BookHelper.getRichEditText(BookHelper.java:1197) >> at org.zkoss.zss.ui.impl.XUtils.getRichEditText(XUtils.java:360) >> at org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:351) >> at org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:81) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3251) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086) >> at org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1691) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:933) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:879) >> at org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:862) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3678) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4941) >> 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:601) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) >> 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) {noformat}

    ZK-Tracker | 3 years ago | paowang
    java.lang.RuntimeException: Zero length string is an invalid sheet name

    Root Cause Analysis

    1. java.lang.RuntimeException

      Zero length string is an invalid sheet name

      at org.zkoss.poi.ss.formula.SheetNameFormatter.needsDelimiting()
    2. org.zkoss.poi
      HSSFCell.getCellFormula
      1. org.zkoss.poi.ss.formula.SheetNameFormatter.needsDelimiting(SheetNameFormatter.java:102)
      2. org.zkoss.poi.ss.formula.SheetNameFormatter.appendFormat(SheetNameFormatter.java:61)
      3. org.zkoss.poi.ss.formula.ptg.ExternSheetNameResolver.prependSheetName(ExternSheetNameResolver.java:44)
      4. org.zkoss.poi.ss.formula.ptg.Ref3DPtg.toFormulaString(Ref3DPtg.java:91)
      5. org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92)
      6. org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83)
      7. org.zkoss.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:624)
      7 frames
    3. org.zkoss.zss
      Spreadsheet.service
      1. org.zkoss.zss.model.sys.impl.BookHelper.getEditText(BookHelper.java:1132)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getRichEditText(BookHelper.java:1197)
      3. org.zkoss.zss.ui.impl.XUtils.getRichEditText(XUtils.java:360)
      4. org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:351)
      5. org.zkoss.zss.ui.impl.XUtils.getEditText(XUtils.java:81)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3251)
      7. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086)
      8. org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1691)
      9. org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:933)
      10. org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:879)
      11. org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:862)
      12. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3678)
      13. org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87)
      14. org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4941)
      14 frames
    4. ZK Kernel
      DHtmlUpdateServlet.doPost
      1. org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:708)
      2. org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1204)
      3. org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601)
      4. org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483)
      5. org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492)
      5 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    6. Jetty Server
      SelectChannelEndPoint.run
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      8. org.mortbay.jetty.Server.handle(Server.java:326)
      9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
      14 frames
    7. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      1 frame