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

    java.io.IOException: Failed on local exception: com.google.protobuf.InvalidProtocolBufferException: Protocol message contained an invalid tag (zero)

    GitHub | 3 years ago | xelllee
    java.lang.RuntimeException: Error preparing HdfsBolt: Failed on local exception: com.google.protobuf.InvalidProtocolBufferException: Protocol message contained an invalid tag (zero).; Host Details : loc al host is: "xxxx"; destination host is: "xxxx":8020;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Kafka: regex validation exception when using configuration property setting for topic in int-kafka:topic-filter

    GitHub | 2 years ago | andrewmilkowski
    org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from class path resource [wda/spring-context-kafka.xml]; nested exception is java.lang.RuntimeException: ${kafka.consumer.topic} is an invalid regex.

    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