Description: Hello, I am using LibreOffice 7.3.1 and working on sheets using Calc. Under “Format” > “Conditional” > “Manage…”, there is a list of Conditional Formats. When “Edit…” is clicked, a list of Conditions will show up. The order of Conditions can, indeed, be changed by the buttons labeled “Up” and “Down”. However, the order of Conditional Formats cannot be changed, as there does not exist similar buttons in the first dialog, but only in the second one. The order of Conditional Formats affects their priority, which then affects the specific formats being applied. Can the feature be added to allow the rearranging of the order of Conditional Formats without removing and adding them one by one? Steps to Reproduce: 1. Go to “Format” > “Conditional” > “Manage…”. 2. Add several Conditional Formats. 3. Attempt to rearrange said Conditional Formats. Actual Results: There exist no option to rearrange the order of Conditional Formats. Expected Results: The order of Conditional Formats can be rearranged through drag and drop or buttons. Reproducible: Always User Profile Reset: No Additional Info: There has been several bug reports in the past that mention a similar feature request, however it should be noted that this request is different and concerns a feature that is not yet available in the newest release at the time of writing.
UX-team, your opinion here?
Created attachment 182896 [details] Manage conditions dialog with more than one condition The CF management dialog shows all conditions in a spreadsheet, for example what is applied to A1:A5 and another for B1:B5. Having two CF for one range sounds like abusing the dialog to easily switch between presets, which might be a use case itself. On the other hand I see no way to suppress multiple CF at one range. And adding up/down interaction is cheap and simple. Perhaps we should do it as icon-only buttons right of the list to not spam the dialog with buttons.
*** Bug 153900 has been marked as a duplicate of this bug. ***
Following comments on https://ask.libreoffice.org/t/calc-how-to-change-conditional-formatting-priority/91488 it seems that the list of conditions is purely alphabetical and does not indicate precedence. In Manage Conditional Formatting it looks as if the Highlighted condition is first in order of applying. For most users, including myself until today, it is not immediately obvious which condition takes precedence just from the appearance of the Manage Conditional Formatting dialogue. This is also against the expectation of the original bug post. Sample with differing order of creation at https://ask.libreoffice.org/t/calc-how-to-change-conditional-formatting-priority/91488/6?u=earnestal
*** Bug 160651 has been marked as a duplicate of this bug. ***
It is worth noticing that the condition being applied is always the matching condition with an older creation date. This is a nightmare when it comes to manage even an amount as small as 2 o 3 overlapping ranges. I've just found out that editing the conditions for a range or even the range itself doesn't change the creation date of the rule. Because there is no way to debug the priority of the rules, this leads to the weird situation that it becomes easier and faster to delete the whole range than to edit it, which won't change priority because the ranges, even when edited, keep their original creation date and thus the priority remains unchanged. In the current state of the main "Manage conditional formatting" dialog, it is impossible to tell which is the priority with which the ranges (with their set of rules) are being applied. If not a way to change the priorities in such dialog, at least an indication of which range is older and is then taking priority is absolutely needed, because otherwise the is no point in changing the ranges when there are overlapping ranges involved. Even with a couple of up and down buttons to reorder the ranges as proposed above, they would be meaningless if the creation date of the range (which determines its priority) or a number showing the priority is not shown.