From a3b26c20215a0bd4701baa97352c0656c9d04783 Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Sat, 14 Aug 2021 09:54:11 +0000 Subject: [PATCH] increase intermediate significance git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892333 13f79535-47bb-0310-9956-ffa450edef68 --- .../apache/poi/ss/formula/atp/PercentRankExcFunction.java | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java b/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java index 7968ed13f2..89e7c1e76e 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java @@ -137,11 +137,12 @@ final class PercentRankExcFunction implements FreeRefFunction { 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; } -- 2.39.5