svn commit: r1893754 - /poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java

[fanningpj]

Author: fanningpj
Date: Thu Sep 30 13:24:18 2021
New Revision: 1893754

URL: http://svn.apache.org/viewvc?rev=1893754&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=1893754&r1=1893753&r2=1893754&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 13:24:18 2021
@@ -152,7 +152,7 @@ class TestFinanceLib extends BaseTestNum
             addRow(sheet, 7, 14500);
             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);
+            Utils.assertDouble(fe, cell, "NPV(A2, A4:A8)+A3", 
1922.061554932363);
             Utils.assertDouble(fe, cell, "NPV(A2, A4:A8, -9000)+A3", 
-3749.4650870155747);
         }
     }



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@poi.apache.org
For additional commands, e-mail: commits-h...@poi.apache.org