This is a follow-up on bug 74074 (on which I added comments 21 to 23 - but somewhat fumbled, I'm afraid... ;-)
I just installed v. 22.214.171.124, and I noticed following effects:
Ordering of the conditional formatting priority, as set in the “Conditional” menu → “Manage...” item → “Edit...” pop-up window with the "Up"- and "Down"-button, is not honored. Apparently (but this has not been tested in further depth) "Colorscale"-types of conditional formatting seem to always have top priority.
Steps to Reproduce:
Please see attachment file "Cond_Form_Ex_20190815.ods", in which I added conditional formatting as well as normal formatting as follows (all formatting and conditional formatting is done to range A2:Z55):
1. the full range A2:Z55 is coloured yellow (unconditional),
2. columns between row 2 and row 55 are colored depending on their value between white (for minimum) and blue (for maximum) (do not be fooled by the progressive coloring of the rows – that is an effect of their progressive numbering, NOT of conditional formatting! The "Colorscale"-type cond. formatting is to the COLUMNS!),
3. any non-numeric or non-empty cells in the range are colored red,
4. any column between row 2 and row 55 is greyed when the cell in row 1 (of that column) is empty.
grey has priority over red (see cell H52 and M52), but blue always has top priority…
priority to grey, then to red, then to blue (see order in “Conditional” menu → “Manage...” item → “Edit...” pop-up window)
User Profile Reset: No
Additionally (but that is a feature request as well as a bug report...) when multiple conditional formats apply (even to different – but overlapping! - ranges), the order of priority of these should ALSO be changeable (with an “Up” and “Down” button in “Conditional” menu → “Manage...” pop-up window)!
Help - About LibreOffice info:
Build ID: 1:6.3.0-0ubuntu0.18.04.1~lo2
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Created attachment 153778 [details]
One unconditional formatting and three unconditional formattings added to range A2:Z55
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: 126.96.36.199 (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
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).
Indeed, the columns you list (as well as Z, but then I'm nitpicking... ;-) )
I'll file that 'feature request' separately and edit the title accordingly (remove the 'b)'-part), but give me some time; I'm learning as I go...
Thanks also for the lead on the colorscale formatting; I wasn't aware! One more thing I learned...