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

ZK-Tracker | paowang | 3 years ago
  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
  3. 0
    SMS Emulator caused this error. abortBroadcast only works with broadcasts sent through Context.sendOrderedBroadcast.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0
    I did this as root, and works dpkg --add-architecture i386 apt-get install libncurses5:i386 libstdc++6:i386 zlib1g:i386
  6. 0
    You might have a JRockit JVM with the management agent started on the same port.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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