<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c6">Comment # 6</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 <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Colin from <a href="show_bug.cgi?id=133746#c5">comment #5</a>) > (In reply to Mike Kaganski from <a href="show_bug.cgi?id=133746#c4">comment #4</a>) > > 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> > > I think I have to disagree. I have other spreadsheets that also have the > same scale of "fixed" percentage results 20,40,60,80,100 and they don't fail > because there is no 50%. It's not actually possible to divide a week by a > whole number of days to get 50% and I am only targeting the five weekdays > which also imposes the same impossibility. Also, the remedy as mentioned in > my <a href="show_bug.cgi?id=133746#c3">comment #3</a>, whilst setting the mean to "real" 0.5 never encounters a > calculated 0.5 but gives a "bug free" result. > Why does deleting any five random rows that also don't contain any 50% > values obviate the bug? > I'm not convinced the colour scale is a standard deviation function. My apologies, it appears I do have one cell containing 0.5 but the exercise of randomly removing 5 rows is unaffected by the inclusion or exclusion of the source data and therefore the value of this cell.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>