0

NotImplementedException: Error evaluating cell (Is it open issue)

asked 2013-05-29 22:26:35 +0800

phasthal gravatar image phasthal
5 3

updated 2013-06-05 02:35:38 +0800

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

delete flag offensive retag edit

4 Answers

Sort by » oldest newest most voted
0

answered 2013-05-31 23:25:13 +0800

phasthal gravatar image phasthal
5 3

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.

link publish delete flag offensive edit

Comments

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

phasthal ( 2013-06-05 02:34:17 +0800 )edit
0

answered 2013-06-05 02:31:53 +0800

phasthal gravatar image phasthal
5 3

updated 2013-06-05 02:34:34 +0800

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)

link publish delete flag offensive edit

Comments

is anybody there to help me out of this issue..

phasthal ( 2013-06-05 17:38:09 +0800 )edit

you can post a bug at http://tracker.zkoss.org/browse/ZSS and monitor it.

dennis ( 2013-06-06 04:29:39 +0800 )edit

thanks dennis. I see that there is a bug already posted http://tracker.zkoss.org/browse/ZSS-321

phasthal ( 2013-06-06 06:20:52 +0800 )edit
0

answered 2013-06-06 09:13:46 +0800

samchuang gravatar image samchuang
4084 4

updated 2013-06-06 09:17:08 +0800

The 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

link publish delete flag offensive edit
0

answered 2013-06-06 17:28:03 +0800

phasthal gravatar image phasthal
5 3

sure, thanks Sam.

link publish delete flag offensive edit
Your answer
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
1 follower

RSS

Stats

Asked: 2013-05-29 22:26:35 +0800

Seen: 18 times

Last updated: Jun 06 '13

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