You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/09/30 09:44:37 UTC
svn commit: r1893750 -
/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java
Author: fanningpj
Date: Thu Sep 30 09:44:37 2021
New Revision: 1893750
URL: http://svn.apache.org/viewvc?rev=1893750&view=rev
Log:
add npv tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java?rev=1893750&r1=1893749&r2=1893750&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java Thu Sep 30 09:44:37 2021
@@ -153,8 +153,7 @@ class TestFinanceLib extends BaseTestNum
HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
HSSFCell cell = wb.getSheetAt(0).getRow(0).createCell(100);
Utils.assertDouble(fe, cell, "NPV(A2, A4:A8)+A3", 1992.061554932363);
- //TODO this scenario does not work
- //Utils.assertDouble(fe, cell, "NPV(A2, A4:A8, -9000)+A3", -3749.47);
+ Utils.assertDouble(fe, cell, "NPV(A2, A4:A8, -9000)+A3", -3749.4650870155747);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org