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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    DataflowAssert doesn't pass TableRow test

    Stack Overflow | 2 years ago | Jorge Z
    java.lang.AssertionError: Expected: iterable over [<{id=x}>] in any order but: Not matched: <{id=x}>
  6. 0

    GitHub comment 5590#30294436

    GitHub | 3 years ago | wildfly-ci
    java.lang.AssertionError: Expected: a string containing "JBAS010881: There is already a deployment called simple1 with the same runtime name SimpleServlet.war on server group main-server-group" but: was "{"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS018785: There is already a deployment called simple1 with the same runtime name SimpleServlet.war"}}}} "

  1. bernardpaulus 7 times, last 4 days ago
  2. ivanszkypeter 6 times, last 4 days ago
  3. rsprangemeijer 1 times, last 6 days ago
  4. marcbouvierdav 1 times, last 2 weeks ago
  5. olle.hallin 1 times, last 3 weeks ago
10 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