https://bugs.documentfoundation.org/show_bug.cgi?id=160805
Bug ID: 160805
Summary: Conditional formatting range does not respond to
insert/delete rows/columns
Product: LibreOffice
Version: 7.6.6.3 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Create a conditional formatting using whatever method.
At a later moment, use insert row(s) or insert column(s) on the range used in
the conditional formatting.
The formatting range is not automatically updated; formulas and named ranges do
automatically update their range specification.
IMHO this is a ux-consistency problem
Steps to Reproduce:
1. Create a conditional formatting using whatever method, using for example
R11:R500
2. insert row(s) on the range used in the conditional formatting. Example: add
10 lines after row 400
3. verify the conditional formatting spec => NO CHANGE
4. enter something in R502 that triggers the conditional formatting => NOT
FORMATTED
Actual Results:
range shows as R11:R500 in Format -> Conditional -> Manage...
cells R501:510 do not change format according to conditions
Expected Results:
should show R11:R510in Format -> Conditional -> Manage...
cells R501:510 should change format according to conditions
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I tried to enter a named range, because they do change with insert/delete
rows/columns but that is not accepted, as already mentioned in bug #160255
--
You are receiving this mail because:
You are the assignee for the bug.
