Bug 162645 - [Calc] Conditional Formatting: Customizable order of formatting rules
Summary: [Calc] Conditional Formatting: Customizable order of formatting rules
Status: RESOLVED DUPLICATE of bug 126047
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-26 22:49 UTC by Lenge
Modified: 2024-08-26 22:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Rules for DIFFERENT (overlapping) cell ranges (74.19 KB, image/jpeg)
2024-08-26 22:54 UTC, Lenge
Details
Conditions for the SAME cell range (85.96 KB, image/jpeg)
2024-08-26 22:56 UTC, Lenge
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lenge 2024-08-26 22:49:52 UTC
Description:
In contrast to Excel, Calc offers no way to control the sequence order in which conditional formatting rules for different overlapping cell ranges are applied. To catch up with Excel, I'd like to suggest the following:

1.) No longer list conditional formatting rules in alphabetical order (with respect to the affected cell ranges), but in the order in which they are actually applied.

2.) Allow re-ordering the rules with "Up" and "Down" buttons, like it is already possible with multiple conditions that refer to the same cell range.

Steps to Reproduce:
In Calc, open the conditional formatting rules list (Format\Conditional\Manage...).

Actual Results:
There are no "Up" and "Down" buttons to re-order the rules and thereby change the order in which they are applied.

Expected Results:
I'd like to be able to control the sequence order (like I can do in Excel).


Reproducible: Always


User Profile Reset: Yes

Additional Info:
I know that you already can re-order multiple conditions that refer to the same cell range. But you cannot do so with rules that affect different (yet overlapping) cell ranges like Excel can.
Comment 1 Lenge 2024-08-26 22:54:27 UTC
Created attachment 196036 [details]
Rules for DIFFERENT (overlapping) cell ranges

Attachment_1.jpg: Rules for DIFFERENT (overlapping) cell ranges cannot be re-ordered in order to control the order in which they are applied.
Comment 2 m_a_riosv 2024-08-26 22:55:23 UTC

*** This bug has been marked as a duplicate of bug 126047 ***
Comment 3 Lenge 2024-08-26 22:56:04 UTC
Created attachment 196037 [details]
Conditions for the SAME cell range

Attachment_2.jpg: Conditions for a single cell range CAN be re-ordered with "Up" and "Down" buttons.