https://bugs.documentfoundation.org/show_bug.cgi?id=169201
Bug ID: 169201
Summary: FORMATTING - Calc - problems with conditional
formatting when shifting cells
Product: LibreOffice
Version: 25.8.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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?
--
You are receiving this mail because:
You are the assignee for the bug.
