java.lang.AssertionError: =ISPMT(B71/12,C71,D71*12,E71) failed, at row 70 in xsheet: formula-financial
Expected: "-64814.81"
     but: was "#NAME?"
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)

java.lang.AssertionError: =PV(0.08/12,20*12,500, ,0) failed, at row 99 in xsheet: formula-financial
Expected: "-59777.15"
     but: was "Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)"
	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.testFinancial(FormulaTest.java:96)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

嚴重的: >>java.lang.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)
>>	at org.zkoss.poi.ss.formula.eval.OperandResolver.coerceValueToDouble(OperandResolver.java:233)
>>	at org.zkoss.poi.ss.formula.functions.NumericFunction.singleOperandEvaluate(NumericFunction.java:38)
>>	at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:53)
>>	at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:69)
>>	at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
>>	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.getFormatText(BookHelper.java:1018)
>>	at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355)
>>	at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89)
>>	at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3066)
>>	at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940)
>>	at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2609)
>>	at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2557)
>>	at org.zkoss.zss.ui.Spreadsheet.access$12(Spreadsheet.java:2506)
>>	at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2266)
>>	at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2256)
>>	at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2015)
>>	at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43)

java.lang.AssertionError: =DDB(B43,C43,D43*365,1) failed, at row 42 in xsheet: formula-financial
Expected: "1.32"
     but: was "1.32 "

java.lang.AssertionError: =FV(B58/12,C58,D58,E58,F58) failed, at row 57 in xsheet: formula-financial
Expected: "2581.40"
     but: was "2581.40 "

java.lang.AssertionError: =NPV(0.08,8000,9200,10000,12000,14500) failed, at row 87 in xsheet: formula-financial
Expected: "41922.06"
     but: was "41922.06 "

java.lang.AssertionError: =PMT(0.08/12,10,10000) failed, at row 89 in xsheet: formula-financial
Expected: "-1037.03"
     but: was "-1037.03 "


java.lang.AssertionError: =PPMT(0.1/12,1,2*12,2000) failed, at row 91 in xsheet: formula-financial
Expected: "-75.62"
     but: was "-75.62 "