Hello, I have some problems with conditional formatting (CF) in Calc. In Excel I was used to set the CF for entire columns for convenience. Just as a very simplified example: CF range A:A (becomes full like A1:A1048576), formula A1=0, style gray text. In the second column B:B, B1=0, gray, etc. When I shift (=copy using the corner) some dynamic cell formulas, the program detects the existing column CF and shifs it too properly, without altering its height range. No problem. LibreOffice Calc, instead, ignores the existing CF and creates sub-ranges, making a mess. It adds a new one every time I shift (horizontally), like A2:B2;C30:E30 etc. At the moment the only workaround seems to avoid shifting and instead use "Paste Special">"Formula" every time, but it’s quite cumbersome. Could this be fixed, please?
Do you need an example for this? LO really makes a mess and then on next restart also tries to fix the duplicates joining ranges. It's impossible to manage the CF like this..