https://bugs.documentfoundation.org/show_bug.cgi?id=133746
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #4 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
