<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746">bug 133746</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746">bug 133746</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>This is not a bug. Using Percentile for intermediate value, you ask it for such
a value that would represent exactly half of the population see [1] that refers
to [2]. Having total of 46 values in the data set used in the conditional
format, and 26 of them being 1, there's no value that would represent half of
the population (23 values). So it necessarily ends up with 1 as the percentile
value, thus being equal to max, and so effectively being equal to 2-color
scale, as the third color is never used.
Possibly what was wanted is using *Percent*, not *Percentile*.
[1] <a href="https://help.libreoffice.org/6.4/en-US/text/scalc/01/05120000.html">https://help.libreoffice.org/6.4/en-US/text/scalc/01/05120000.html</a>
[2] <a href="https://wiki.documentfoundation.org/Faq/Calc/142">https://wiki.documentfoundation.org/Faq/Calc/142</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>