0

Workbook display error. (ptgs must not be null)

asked 2012-05-04 03:48:04 +0800

baba gravatar image baba
27

Hi,

I'm trying to display a workbook in my web page. But im having this problem, 'ptgs must not be null'.
Im using the latest ZK spreadsheet 2.3.

Here is the complete error.


Stacktrace:] with root cause
java.lang.IllegalArgumentException: ptgs must not be null
at org.zkoss.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:48)
at org.zkoss.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:83)
at org.zkoss.zss.model.impl.HSSFSheetImpl$DVRecordVisitor.createContraint(HSSFSheetImpl.java:1173)
at org.zkoss.zss.model.impl.HSSFSheetImpl$DVRecordVisitor.visitRecord(HSSFSheetImpl.java:1137)
at org.zkoss.poi.hssf.record.aggregates.DataValidityTable.visitContainedRecords(DataValidityTable.java:62)
at org.zkoss.zss.model.impl.HSSFSheetImpl.getDataValidations(HSSFSheetImpl.java:1115)
at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1671)
at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1809)
at org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1886)
at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1828)
at org.zkoss.jsp.zul.impl.PageRenderer.render(PageRenderer.java:117)
at org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:834)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:489)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312)
at org.zkoss.jsp.zul.impl.RootTag.doTag(RootTag.java:275)
at org.apache.jsp.Process.webExcelSubmission_jsp._jspx_meth_z_005fpage_005f0(webExcelSubmission_jsp.java:725)
at org.apache.jsp.Process.webExcelSubmission_jsp._jspService(webExcelSubmission_jsp.java:393)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

delete flag offensive retag edit

1 Reply

Sort by ยป oldest newest

answered 2012-06-25 06:28:29 +0800

jimmyshiau gravatar image jimmyshiau
4921 5
http://www.zkoss.org/ ZK Team

Hi baba,

Can you provide a runable sample?
and what ZK version are you using?

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2012-05-04 03:48:04 +0800

Seen: 110 times

Last updated: Jun 25 '12

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More