https://bugs.documentfoundation.org/show_bug.cgi?id=171977
Bug ID: 171977
Summary: Conditional formatting "full sheet" range to prevent
fragmentation
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I like to create conditional formatting rules that should apply to the complete
sheet. To do this, I will set the range to "A1:XFD1048576".
Unfortunately, there are many operations that will fragment this range. This
has been reported in multiple issues:
https://bugs.documentfoundation.org/buglist.cgi?quicksearch=conditional%20formatting%20range%20fragment&list_id=1975202.
Among them is cut + paste.
After the range has been fragmented, I need to remember the "A1:XFD1048576" to
properly restore it.
As a solution, I propose to add a checkbox "full sheet" or "all cells", or a
placeholder for "all cells" that can be inserted in the "Range" textfield in
the "Conditional formatting for ..." dialog.
If a conditional formatting rule is marked as "all cells", LibreOffice Calc
won't fragment it.
Steps to Reproduce:
1. Select all cells in sheet, by clicking the top left corner.
2. Open "Format" / "Conditional" / "Manage..." menu.
3. Click "Add".
4. Create a rule with a formula, e.g. to apply heading 2 style if $A1 = "".
Save.
5. Select one cell, ctrl+x, select other cell and ctrl+v.
6. Open "Format" / "Conditional" / "Manage..." menu.
7. Inspect the rule we created earlier.
Actual Results:
Step 3:
In the add rule dialog, the "Range" textfield is pre-filled with
"A1:XFD1048576".
Step 7:
The "Range" field is now fragmented, like "B1:XFD1048576,A1:A45,A47:A1048576".
(If a different operation was done in step 5, even the formulas might be
altered)
Expected Results:
Step 3:
In the dialog to add a rule, in "Cell range", there is a pre-filled checkbox
"all cells", and the range textfield is greyed out.
OR
The "Cell range" is pre-filled with a placeholder that represents "all cells".
Step 7:
The rule still applies to all cells.
Reproducible: Always
User Profile Reset: No
Additional Info:
It's a known issue that severely impacts user experience.
The motivation for me to use conditional formatting is to avoid having to deal
with custom styles all the time, or manually apply styles to certain cells.
But this convenience is completely negated by the need to repair these ranges
all the time.
--
You are receiving this mail because:
You are the assignee for the bug.
