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/14 09:54:11 UTC
svn commit: r1892333 -
/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java
Author: fanningpj
Date: Sat Aug 14 09:54:11 2021
New Revision: 1892333
URL: http://svn.apache.org/viewvc?rev=1892333&view=rev
Log:
increase intermediate significance
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java
Modified: poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java?rev=1892333&r1=1892332&r2=1892333&view=diff
==============================================================================
--- poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java (original)
+++ poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java Sat Aug 14 09:54:11 2021
@@ -137,11 +137,12 @@ final class PercentRankExcFunction imple
BigDecimal result = new BigDecimal((double)(lessThanCount + 1) / (double)(numbers.size() + 1));
return new NumberEval(PercentRank.round(result, significance));
} else {
- ValueEval belowRank = calculateRank(numbers, closestMatchBelow, significance + 3, false);
+ int intermediateSignificance = significance < 5 ? 8 : significance + 3;
+ ValueEval belowRank = calculateRank(numbers, closestMatchBelow, intermediateSignificance, false);
if (!(belowRank instanceof NumberEval)) {
return belowRank;
}
- ValueEval aboveRank = calculateRank(numbers, closestMatchAbove, significance + 3, false);
+ ValueEval aboveRank = calculateRank(numbers, closestMatchAbove, intermediateSignificance, false);
if (!(aboveRank instanceof NumberEval)) {
return aboveRank;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org