-
Bug
-
Resolution: Fixed
-
Normal
-
3.0.0 RC
Problem description:
when we enter a formula with miss required arguments, it throws NotImplementedException.
>>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell temp!J10
>>org.zkoss.poi.ss.formula.eval.NotImplementedException: ACCRINT, not in zk context
>> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109)
>> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:159)
>> 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)
>> 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.sys.impl.BookHelper.evaluate(BookHelper.java:492)
>> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:319)
>> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:478)
>> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:422)
>> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:386)
>> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:606)
>> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4370)
>> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4333)
>> at org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:4331)
>> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:324)
reproducing Steps:
- open the spreadsheet
- enter "=ACCRINT()"
Expected:
#VALUE!
Actual:
the exception shown above.
- relates to
-
ZSS-572 Incorrect formula throws an exception
- Closed