diff options
| author | PJ Fanning <fanningpj@apache.org> | 2021-09-30 13:24:18 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2021-09-30 13:24:18 +0000 |
| commit | dc5451ea3e9400a43eca8404d3d07ef048a966c6 (patch) | |
| tree | 1b9a258bf8f6a9f95828d09880b4a92a5ed8340a /poi/src | |
| parent | 2bf5cd505b620baebb85a41f934cb90c60ed5fd8 (diff) | |
| download | poi-dc5451ea3e9400a43eca8404d3d07ef048a966c6.tar.gz poi-dc5451ea3e9400a43eca8404d3d07ef048a966c6.zip | |
add npv tests
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1893754 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi/src')
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java index 33bc49d9df..7028743dbf 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestFinanceLib.java @@ -152,7 +152,7 @@ class TestFinanceLib extends BaseTestNumeric { 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); } } |