https://bugs.documentfoundation.org/show_bug.cgi?id=148154
--- Comment #6 from barruel <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
