java.lang.NullPointerException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • {code} Invalid format: "[$£-809]#,##0.00" java.lang.NullPointerException at org.zkoss.poi.ss.format.CellElapsedFormatter.<init>(CellElapsedFormatter.java:145) at org.zkoss.poi.ss.format.CellFormatType$4.formatter(CellFormatType.java:62) at org.zkoss.poi.ss.format.CellFormatPart.getFormatter(CellFormatPart.java:320) at org.zkoss.poi.ss.format.CellFormatPart.<init>(CellFormatPart.java:188) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:195) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1047) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1646) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1416) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1228) 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) 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) 2013/6/11 上午 11:43:38 org.zkoss.poi.ss.format.CellFormat <init> 警告: Invalid format: "[DBNum1][$-404]m"月"d"日";" java.lang.NullPointerException at org.zkoss.poi.ss.format.CellElapsedFormatter.<init>(CellElapsedFormatter.java:145) at org.zkoss.poi.ss.format.CellFormatType$4.formatter(CellFormatType.java:62) at org.zkoss.poi.ss.format.CellFormatPart.getFormatter(CellFormatPart.java:320) at org.zkoss.poi.ss.format.CellFormatPart.<init>(CellFormatPart.java:188) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:195) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1047) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1646) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1416) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1228) 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) 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}
    via by dennis,
  • {code} Invalid format: "[$£-809]#,##0.00" java.lang.NullPointerException at org.zkoss.poi.ss.format.CellElapsedFormatter.<init>(CellElapsedFormatter.java:145) at org.zkoss.poi.ss.format.CellFormatType$4.formatter(CellFormatType.java:62) at org.zkoss.poi.ss.format.CellFormatPart.getFormatter(CellFormatPart.java:320) at org.zkoss.poi.ss.format.CellFormatPart.<init>(CellFormatPart.java:188) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:195) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1047) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1646) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1416) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1228) 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) 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) 2013/6/11 上午 11:43:38 org.zkoss.poi.ss.format.CellFormat <init> 警告: Invalid format: "[DBNum1][$-404]m"月"d"日";" java.lang.NullPointerException at org.zkoss.poi.ss.format.CellElapsedFormatter.<init>(CellElapsedFormatter.java:145) at org.zkoss.poi.ss.format.CellFormatType$4.formatter(CellFormatType.java:62) at org.zkoss.poi.ss.format.CellFormatPart.getFormatter(CellFormatPart.java:320) at org.zkoss.poi.ss.format.CellFormatPart.<init>(CellFormatPart.java:188) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:195) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1047) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1646) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1416) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1228) 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) 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}
    via by dennis,
    • java.lang.NullPointerException at org.zkoss.poi.ss.format.CellElapsedFormatter.<init>(CellElapsedFormatter.java:145) at org.zkoss.poi.ss.format.CellFormatType$4.formatter(CellFormatType.java:62) at org.zkoss.poi.ss.format.CellFormatPart.getFormatter(CellFormatPart.java:320) at org.zkoss.poi.ss.format.CellFormatPart.<init>(CellFormatPart.java:188) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:195) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1047) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1646) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1416) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1228) 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) 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)
    No Bugmate found.