[github-193] Change TRUNC implementation to use MathX. Thanks to Jacob Harris. This closes #193

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1882706 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 15 insertions, 0 deletions

diff --git a/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java b/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java
index a501435616..c8f4d90f5f 100644
--- a/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java
+++ b/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java
@@ -58,6 +58,21 @@ public final class TestTrunc extends BaseTestNumeric {
 	}
 
 	@Test
+	public void testTruncWithProblematicDecimalNumber() {
+		ValueEval[] args = { new NumberEval(0.29), new NumberEval(2) };
+		ValueEval result = NumericFunction.TRUNC.evaluate(args, -1, (short)-1);
+		assertEquals("TRUNC", (new NumberEval(0.29d)).getNumberValue(), ((NumberEval)result).getNumberValue());
+	}
+
+	@Test
+	public void testTruncWithProblematicCalculationResult() {
+
+		ValueEval[] args = { new NumberEval(21.624d / 24d + .009d), new NumberEval(2) };
+		ValueEval result = NumericFunction.TRUNC.evaluate(args, -1, (short)-1);
+		assertEquals("TRUNC", (new NumberEval(0.91d)).getNumberValue(), ((NumberEval)result).getNumberValue());
+	}
+
+	@Test
 	public void testTruncWithDecimalNumberOneArg() {
 		ValueEval[] args = { new NumberEval(2.612777) };
 		ValueEval result = NumericFunction.TRUNC.evaluate(args, -1, (short)-1);