-
Bug
-
Resolution: Fixed
-
Normal
-
2.5.0, 3.0.0 RC
problem description
by automatic test the Math formula SERIESSUM cannot be evaluated to a correct result.
java.lang.AssertionError: =SERIESSUM(B105,0,2,B106:B109) failed, at row 104 in xsheet: formula-math Expected: "0.7071" but: was "Error evaluating cell 'formula-math'!B104" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20) at org.junit.Assert.assertThat(Assert.java:865) at org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65) at org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78) at org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63) at zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158) at zss.test.FormulaTest.testMath(FormulaTest.java:51) ...
Exception:
嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'first-error'!F20
>>org.zkoss.poi.ss.formula.eval.NotImplementedException: SERIESSUM
>> 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)
>> 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:476)
>> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:303)
>> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:462)
>> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:421)
>> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:385)
>> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:604)
>> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4381)
>> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4344)
>> at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:4342)
>> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:318)
reproducing steps
run automatic test case FormulaTest of the project zss.test of zkspreadsheet
- blocks
-
ZSS-321 Unsupported formulas cause an exception and crashed
- Closed
-
ZSS-341 2 statistical formulas throw NotImplementedException
- Closed
- is blocked by
-
ZSS-321 Unsupported formulas cause an exception and crashed
- Closed
- relates to
-
ZSS-341 2 statistical formulas throw NotImplementedException
- Closed