You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/08/07 15:02:49 UTC
svn commit: r1892082 - in
/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula:
atp/TestPercentRankIncFunction.java functions/TestPercentRank.java
Author: fanningpj
Date: Sat Aug 7 15:02:49 2021
New Revision: 1892082
URL: http://svn.apache.org/viewvc?rev=1892082&view=rev
Log:
[bug-49202] add PERCENTRANK.INC function
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestPercentRankIncFunction.java
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestPercentRank.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestPercentRankIncFunction.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestPercentRankIncFunction.java?rev=1892082&r1=1892081&r2=1892082&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestPercentRankIncFunction.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestPercentRankIncFunction.java Sat Aug 7 15:02:49 2021
@@ -48,6 +48,8 @@ public class TestPercentRankIncFunction
assertDouble(fe, cell, "PERCENTRANK.INC(A2:A11,8,2)", 0.66);
assertDouble(fe, cell, "PERCENTRANK.INC(A2:A11,8,4)", 0.6666);
assertDouble(fe, cell, "PERCENTRANK.INC(A2:A11,5)", 0.583);
+ assertDouble(fe, cell, "PERCENTRANK(A2:A11,1)", 0);
+ assertDouble(fe, cell, "PERCENTRANK(A2:A11,13)", 1);
}
}
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestPercentRank.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestPercentRank.java?rev=1892082&r1=1892081&r2=1892082&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestPercentRank.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestPercentRank.java Sat Aug 7 15:02:49 2021
@@ -47,6 +47,8 @@ public class TestPercentRank {
assertDouble(fe, cell, "PERCENTRANK(A2:A11,8,2)", 0.66);
assertDouble(fe, cell, "PERCENTRANK(A2:A11,8,4)", 0.6666);
assertDouble(fe, cell, "PERCENTRANK(A2:A11,5)", 0.583);
+ assertDouble(fe, cell, "PERCENTRANK(A2:A11,1)", 0);
+ assertDouble(fe, cell, "PERCENTRANK(A2:A11,13)", 1);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org