[Libreoffice-bugs] [Bug 133746] Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133746

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
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] https://help.libreoffice.org/6.4/en-US/text/scalc/01/05120000.html
[2] https://wiki.documentfoundation.org/Faq/Calc/142

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200607/8810c079/attachment.htm>