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

ZK-Tracker | hawk | 4 years ago
  1. 0

    h3. problem description: not found formula: ISPMT, LOGEST, MIRR, VDB {code} 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) {code} \\ \\ \\ ---- error in evaluating PV(0.08/12,20*12,500, ,0) {code} 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) {code} Exception stack trace: {code} 嚴重的: >>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) {code} \\ \\ \\ ---- some formula evaluation results are slightly different from expected (one more space character than expected): *DDB, FV, NPV, SLN, SYD, PMT, PPMT* {code} 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 " {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file

    ZK-Tracker | 4 years ago | hawk
    java.lang.AssertionError: =ISPMT(B71/12,C71,D71*12,E71) failed, at row 70 in xsheet: formula-financial Expected: "-64814.81" but: was "#NAME?"
  2. 0

    h3. problem description: not found formula: ISPMT, LOGEST, MIRR, VDB {code} 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) {code} \\ \\ \\ ---- error in evaluating PV(0.08/12,20*12,500, ,0) {code} 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) {code} Exception stack trace: {code} 嚴重的: >>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) {code} \\ \\ \\ ---- some formula evaluation results are slightly different from expected (one more space character than expected): *DDB, FV, NPV, SLN, SYD, PMT, PPMT* {code} 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 " {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file

    ZK-Tracker | 4 years ago | hawk
    java.lang.AssertionError: =ISPMT(B71/12,C71,D71*12,E71) failed, at row 70 in xsheet: formula-financial Expected: "-64814.81" but: was "#NAME?"
  3. 0

    rexsl-test failure

    GitHub | 4 years ago | simonjenga
    java.lang.AssertionError: XPath '//y[.='\u0443\u0440\u0430!']' has to exist in: HTTP request: HTTP request body HTTP response (200): <x a='1'><!-- hi --><y>???!</y></x> Expected: not an empty collection but: was <ListWrapper(original=[], dom=[x: null], xpath=//y[.='???!'])>
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Expected/actual dialogue for failed tests not working when using hamcrest

    GitHub | 6 years ago | t-jones
    java.lang.AssertionError: test blah failed Expected: is "blah blah blah" but: was "yada yada yada"

  1. olle.hallin 1 times, last 2 weeks ago
  2. davidvanlaatum 7 times, last 4 weeks ago
  3. cesarnog 1 times, last 2 months ago
  4. tfr 1 times, last 4 months ago
  5. qoomon 1 times, last 4 months ago
1 more registered users
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Hamcrest
    MatcherAssert.assertThat
    1. org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
    1 frame