[Libreoffice-bugs] [Bug 127252] Priority ordering of conditional formatting in Calc as proposed in Bug 74074, Comment 19, a) does not work, b) is not sufficient.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
In essence: in columns D, G, H, L, M, P, Q, V, there should not be any cell
colouring but grey, since that's what the first matching condition tells.

I confirm this to be broken (having blue cells with numbers in those columns)
with Version: 6.3.1.1 (x64)
Build ID: e979878b49a48dab15ebe528f238b88125e32c65
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

The feature request (about different conditional formats in possibly different
overlapping ranges) must not be handled along with the bug report, so please
file it separately, and ignore it here.

The part about #2 ("columns between row 2 and row 55 are colored ... do not be
fooled by the progressive coloring of the rows") - this seems to be
misunderstanding. The color scale conditional format does not differentiate
between rows and columns; it is applied to the range as a whole, and it
analyzes all the cells in the whole range to decide which value would get which
color (e.g., put 2500 to Z53, and see that all other numeric cells in all
rows/columns get ~white).

-- 
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/20190831/15431194/attachment.html>