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
No repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5740d3fa83e9725a2771e5f00ba4aaf9965f0be2 CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo Created conditional formatting range A1:A10. After insert new row 5 is range A1:A11. Tested with condition Color scale.
I confirm solution by raal Just downloaded 24.2.2.2 and the problem is gone. I tried inserting rows and entering values for many different combinations: insert before/after a matching condition 1, insert before/after a match condition 2, insert before/after a value that does not match any of the conditions and ALL BEHAVE AS EXPECTED. Thank you for the solution. Dirk
Thanks, closing