Bug 148154 - Reordering Conditional Formats in Manage CF dialog
Summary: Reordering Conditional Formats in Manage CF dialog
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 153900 (view as bug list)
Depends on:
Blocks: Conditional-Formatting-Managing
  Show dependency treegraph
Reported: 2022-03-23 23:50 UTC by Carl2333
Modified: 2023-05-14 22:52 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Manage conditions dialog with more than one condition (21.46 KB, image/png)
2022-10-07 08:28 UTC, Heiko Tietze

Note You need to log in before you can comment on or make changes to this bug.
Description Carl2333 2022-03-23 23:50:04 UTC

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.
Comment 1 Roman Kuznetsov 2022-10-06 19:07:00 UTC
UX-team, your opinion here?
Comment 2 Heiko Tietze 2022-10-07 08:28:32 UTC
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.
Comment 3 m.a.riosv 2023-03-01 22:32:35 UTC
*** Bug 153900 has been marked as a duplicate of this bug. ***
Comment 4 Alistair Saywell 2023-05-14 22:52:30 UTC
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