-
FEATURED COMPONENTS
First time here? Check out the FAQ!
Hi,
I have downloaded latest ZSS 2.5.0 and ZKEE eval version 6.5.2.
I am getting below exception while loading excel sheet (when it has formulas to evaluate), please see the stacktrace for reference.
Looks like there is a similar bug (ZSS-218), please let me know if this fixed.
org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-datetime'!B6 org.zkoss.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:385) org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:326) org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:469) org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1011) org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3022) org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2868) org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1645) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1806) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1883) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1825) org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104) org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56) org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause
org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:93) org.zkoss.poi.ss.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:62) org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:469) org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1011) org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3022) org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2868) org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1645) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1806) org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1883) org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1825) org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104) org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56) org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
Regards, Praveen
I have downloaded latest 2.6.0 and verified, got same exception.
Then, By changing the date format in the sheet for DateValue function, it was working fine (without exception). It was 2008/1/1, changed to 1/1/2008.
Looks like issue was with data.
Again, I am getting this exception (Caused by: org.zkoss.poi.ss.formula.eval.NotImplementedException: EOMONTH) while loading excel,
the formula used in the sheet is = DAY(EOMONTH(A2,0)) and sample data in A2=5/4/2013
It is able to evaluate in excel file but failing when loading excel sheet using zk-spreadsheet.
Is this open issue?
below is the stacktrace for reference:
org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell Sheet1!C2 at org.zkoss.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:385) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:326) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) at org.zkoss.zss.model.impl.BookHelper.evaluate(BookHelper.java:471) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1013) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271) at org.zkoss.zss.ui.impl.Utils.getFormatText(Utils.java:915) at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3032) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2878) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1647) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1806) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:975) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:672) 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:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: org.zkoss.poi.ss.formula.eval.NotImplementedException: EOMONTH at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316)
you can post a bug at http://tracker.zkoss.org/browse/ZSS and monitor it.
dennis ( 2013-06-06 04:29:39 +0800 )editThe formula "EOMONTH" is not supported yet, you can post feature request or try to implement custom formula
you can refer to Implement Your Own Formula Functions
Asked: 2013-05-29 22:26:35 +0800
Seen: 19 times
Last updated: Jun 06 '13