java.lang.NullPointerException

ZK-Tracker | hawk | 4 years ago
  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 | 11 months 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