diff options
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/atp/TestMRound.java | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/atp/TestMRound.java b/poi/src/test/java/org/apache/poi/ss/formula/atp/TestMRound.java index da3e67e4be..20fd4b2099 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/atp/TestMRound.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/atp/TestMRound.java @@ -100,10 +100,12 @@ class TestMRound { Cell b3 = row2.createCell(1); b3.setCellValue(1.35); - double accuracy = 1E-9; + double accuracy = 1E-12; FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator(); + assertEquals(1.2205, evaluator.evaluate(a2).getNumberValue(), accuracy); + assertEquals(1.175, evaluator.evaluate(b2).getNumberValue(), accuracy); assertEquals(0.19775, evaluator.evaluate(c1).getNumberValue(), accuracy); assertEquals(19.78, evaluator.evaluate(d1).getNumberValue(), accuracy); d1.setCellFormula("MROUND(C1 * 100, 2)"); |