<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Priority ordering of conditional formatting in Calc as proposed in Bug 74074, Comment 19, a) does not work, b) is not sufficient." href="https://bugs.documentfoundation.org/show_bug.cgi?id=127252#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Priority ordering of conditional formatting in Calc as proposed in Bug 74074, Comment 19, a) does not work, b) is not sufficient." href="https://bugs.documentfoundation.org/show_bug.cgi?id=127252">bug 127252</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>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).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>