java.lang.NullPointerException

ZK-Tracker | hawk | 4 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

    h3. problem description [cell-data] \ data validation. if a sheet contains "data validation" configuration with empty criteria, it causes null pointer exception when displaying it, then crashed {code} >>java.lang.NullPointerException >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1009) >> at org.zkoss.zss.model.sys.impl.BookHelper.getCellText(BookHelper.java:1032) >> at org.zkoss.zss.model.sys.impl.BookHelper.getValidationList(BookHelper.java:4927) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1481) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1451) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:856) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:791) >> at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:769) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:79) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4712) >> at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:701) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1201) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) {code} h3. reproducing steps you can "cell-data" sheet in the attachment to reproduce it.

    ZK-Tracker | 4 years ago | hawk
    java.lang.NullPointerException
  2. 0

    h3. problem description [cell-data] \ data validation. if a sheet contains "data validation" configuration with empty criteria, it causes null pointer exception when displaying it, then crashed {code} >>java.lang.NullPointerException >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1009) >> at org.zkoss.zss.model.sys.impl.BookHelper.getCellText(BookHelper.java:1032) >> at org.zkoss.zss.model.sys.impl.BookHelper.getValidationList(BookHelper.java:4927) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1481) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1451) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:856) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:791) >> at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:769) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:79) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4712) >> at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:701) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1201) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) {code} h3. reproducing steps you can "cell-data" sheet in the attachment to reproduce it.

    ZK-Tracker | 4 years ago | hawk
    java.lang.NullPointerException
  3. 0

    GitHub comment 151#169586491

    GitHub | 1 year ago | janbartel
    java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    1.load a book and enabel sheetbar by setShowSheetbar(true); 2.click add new sheet 3.double click on new sheet (on sheetbar) and rename it. 4. get NPE when I try to rename sheet {code} >>java.lang.NullPointerException >> at org.zkoss.zss.model.impl.XSSFBookImpl.ranameSheetInAppXml(XSSFBookImpl.java:262) >> at org.zkoss.zss.model.impl.XSSFBookImpl.setSheetName(XSSFBookImpl.java:253) >> at org.zkoss.zss.model.impl.RangeImpl.setSheetName(RangeImpl.java:2374) >> at org.zkoss.zss.ui.au.in.ActionCommand.processSheet(ActionCommand.java:87) >> at org.zkoss.zss.ui.au.in.ActionCommand.process(ActionCommand.java:59) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4655) >> at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:698) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1194) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:583) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:481) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:489) >> 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) {code}

    ZK-Tracker | 4 years ago | dennis
    java.lang.NullPointerException
  6. 0

    h3. Reproducing Steps: # run zss.test/display.zul # select {{cell-data}} sheet *Actual:* An exception is thrown. {quote} 2014/1/22 下午 02:54:45 org.zkoss.zk.ui.impl.UiEngineImpl handleError:1352 嚴重的: >>java.lang.NullPointerException >> at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1009) >> at org.zkoss.zss.model.impl.BookHelper.getCellText(BookHelper.java:1032) >> at org.zkoss.zss.model.impl.BookHelper.getValidationList(BookHelper.java:4947) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1459) >> at org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1429) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:828) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:769) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:78) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4735) >> at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:698) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1194) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:583) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:481) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:489) >> 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) {quote} *Expected:* no error and display the sheet content.

    ZK-Tracker | 3 years ago | hawk
    java.lang.NullPointerException

    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.NullPointerException

      No message provided

      at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText()
    2. org.zkoss.zss
      Spreadsheet.service
      1. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1009)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getCellText(BookHelper.java:1032)
      3. org.zkoss.zss.model.sys.impl.BookHelper.getValidationList(BookHelper.java:4927)
      4. org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1481)
      5. org.zkoss.zss.ui.Spreadsheet.convertDataValidationToJSON(Spreadsheet.java:1451)
      6. org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:856)
      7. org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:791)
      8. org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:769)
      9. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3520)
      10. org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:79)
      11. org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4712)
      11 frames
    3. ZK Kernel
      DHtmlUpdateServlet.doPost
      1. org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:701)
      2. org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1201)
      3. org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600)
      4. org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482)
      5. org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491)
      5 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      1 frame