XPAGES with Customize excel cells

asked 2013-08-28 15:23:18 +0800

jtajo
1

Hi

Good day to all!

My subject is about zk spreadsheet inside xpages.

I have setup the zk plugins into lotus designer and succesfully able to view the sample nsf with xpages . I took this sample from the download site. The rendering of sample nsf when smooth

Finally I took our existing excel file (this contains comboxes, computed formulas). When preview the xpages with this excel file , I got the following errors. If I use a plain excel file without comboboxes, computed cells , xpages with zk working just fine.

I am not a java guy and could not interpret the errors below.

Any help would be great!! Looking forward to answers

java.lang.NullPointerException org.zkoss.poi.ss.format.CellFormat.(CellFormat.java:160) org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:125) org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:909) org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:248) org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:895) org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:82) org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellOuterAttrs(Spreadsheet.java:2263) org.zkoss.zss.ui.fn.UtilFns.getCellOuterAttrs(UtilFns.java:170) org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1204) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1729) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1808) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1748) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1808) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1748) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1808) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1748) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1808) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1748) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1808) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1748) org.zkoss.zk.ui.sys.HtmlPageRenders.outStandalone(HtmlPageRenders.java:850) org.zkoss.zkplus.embed.Renders$PageRenderer.render(Renders.java:207) org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:831) org.zkoss.zk.ui.impl.UiEngineImpl.redrawNewPage(UiEngineImpl.java:567) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:474) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:302) org.zkoss.zkplus.embed.Renders.render(Renders.java:136) org.zkoss.xpage.core.renderkit.zul.ZulRendererBase.newZKComponent(ZulRendererBase.java:175) org.zkoss.xpage.core.renderkit.zul.ZulRendererBase.encodeEnd(ZulRendererBase.java:81) com.ibm.xsp.renderkit.ReadOnlyAdapterRenderer.encodeEnd(ReadOnlyAdapterRenderer.java:153) javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:1005) com.ibm.xsp.util.FacesUtil.renderComponent(FacesUtil.java:809) com.ibm.xsp.util.FacesUtil.renderComponent(FacesUtil.java:804) com.ibm.xsp.util.FacesUtil.renderComponent(FacesUtil.java:804) com.ibm.xsp.util.FacesUtil.renderComponent(FacesUtil.java:804) com.ibm.xsp.component.UIViewRootEx.renderView(UIViewRootEx.java:1272) com.ibm.xsp.component.UIViewRootEx.renderView(UIViewRootEx.java:1210) com.ibm.xsp.application.ViewHandlerExImpl.doRender(ViewHandlerExImpl.java:635) com.ibm.xsp.application.ViewHandlerExImpl.renderView(ViewHandlerExImpl.java:320) com.ibm.xsp.application.ViewHandlerExImpl.renderView(ViewHandlerExImpl.java:355) com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:103) com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:210) com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:120) com.ibm.xsp.controller.FacesControllerImpl.render(FacesControllerImpl.java:264) com.ibm.xsp.webapp.FacesServlet.serviceView(FacesServlet.java:219) com.ibm.xsp.webapp.FacesServletEx.serviceView(FacesServletEx.java:193) com.ibm.xsp.webapp.FacesServlet.service(FacesServlet.java:154) com.ibm.xsp.webapp.FacesServletEx.service(FacesServletEx.java:137) com.ibm.xsp.webapp.DesignerFacesServlet.service(DesignerFacesServlet.java:86) com.ibm.designer.runtime.domino.adapter.ComponentModule.invokeServlet(ComponentModule.java:538) com.ibm.domino.xsp.module.nsf.NSFComponentModule.invokeServlet(NSFComponentModule.java:1140) com.ibm.designer.runtime.domino.adapter.ComponentModule$AdapterInvoker.invokeServlet(ComponentModule.java:803) com.ibm.designer.runtime.domino.adapter.ComponentModule$ServletInvoker.doService(ComponentModule.java:758) com.ibm.designer.runtime.domino.adapter.ComponentModule.doService(ComponentModule.java:527) com.ibm.domino.xsp.module.nsf.NSFComponentModule.doService(NSFComponentModule.java:1124) com.ibm.domino.xsp.module.nsf.NSFService.doServiceInternal(NSFService.java:513) com.ibm.domino.xsp.module.nsf.NSFService.doService(NSFService.java:342) com.ibm.designer.runtime.domino.adapter.LCDEnvironment.doService(LCDEnvironment.java:304) com.ibm.designer.runtime.domino.adapter.LCDEnvironment.service(LCDEnvironment.java:261) com.ibm.domino.xsp.bridge.http.engine.XspCmdManager.service(XspCmdManager.java:291)