Author: fanningpj
Date: Thu Feb 3 10:05:38 2022
New Revision: 1897715
URL: http://svn.apache.org/viewvc?rev=1897715&view=rev
Log:
add INT tests
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NumericFunction.java
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumericFunction.java
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NumericFunction.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NumericFunction.java?rev=1897715&r1=1897714&r2=1897715&view=diff
==============================================================================
---
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NumericFunction.java
(original)
+++
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NumericFunction.java
Thu Feb 3 10:05:38 2022
@@ -100,6 +100,7 @@ public abstract class NumericFunction im
public static final Function EXP = oneDouble(d -> Math.pow(Math.E, d));
public static final Function FACT = oneDouble(MathX::factorial);
+
//https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef
public static final Function INT = oneDouble(d -> Math.round(d-0.5));
public static final Function LN = oneDouble(Math::log);
public static final Function LOG10 = oneDouble(d -> Math.log(d) /
LOG_10_TO_BASE_e);
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumericFunction.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumericFunction.java?rev=1897715&r1=1897714&r2=1897715&view=diff
==============================================================================
---
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumericFunction.java
(original)
+++
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumericFunction.java
Thu Feb 3 10:05:38 2022
@@ -30,8 +30,12 @@ final class TestNumericFunction {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFCell cell = wb.createSheet().createRow(0).createCell(0);
HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
- assertDouble(fe, cell, "880000000*0.00849", 7471200.0, 0.00000001);
- assertDouble(fe, cell, "880000000*0.00849/3", 2490400.0, 0.00000001);
- assertDouble(fe, cell, "INT(880000000*0.00849/3)", 2490400.0,
0.00000001);
+ assertDouble(fe, cell, "INT(880000000.0001)", 880000000.0, 0);
+ //the following INT(-880000000.0001) resulting in -880000001.0 has
been observed in excel
+ //see also
https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef
+ assertDouble(fe, cell, "INT(-880000000.0001)", -880000001.0, 0);
+ assertDouble(fe, cell, "880000000*0.00849", 7471200.0, 0);
+ assertDouble(fe, cell, "880000000*0.00849/3", 2490400.0, 0);
+ assertDouble(fe, cell, "INT(880000000*0.00849/3)", 2490400.0, 0);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
