[Libreoffice-bugs] [Bug 131471] Rendering of background changes due to conditional formatting fails in merged cells across multiple rows in some cases in Calc.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131471

--- Comment #4 from Eric B. Pratt <eric.b.pratt at gmail.com> ---
I have found a workaround that may help pinpoint the bug a little more closely.
 In the first attachment, the conditional formatting was applied by these
steps:

1) Select one of the merged cells
2) Create and apply the conditional formatting to it
3) Copy and paste the cell to the other merged cells that use the same
condition

However, I have tried this a different way that appears to solve the problem
from a user's perspective.  By replacing step 1 above with selecting all the
cells in a continuous range and skipping step 3, the problem does not manifest.

1) Select desired cells in a continuous range
2) Create and apply the conditional formatting to them

I'm uploading a new attachment that shows the selected range method.  However,
in this attachment, I did not precisely follow the method described above.  I
used the previous attachment that showed the problem and opened the "Manage
Conditional Formatting" dialogue.  Then I replaced the comma separated list of
cells to apply each format with a range that included all of the merged cells
that needed that condition.  So this is not something that requires the
condition to be set with ranges at the creation of the conditional formatting
instance.

In the example, it also doesn't matter whether the range for the third merged
cell column is R11:R27 or R11:S28.  Both ranges work without showing the bug.

While this workaround does suffice for my situation, if a non-continuous set of
cells needs the same conditional formatting rule, the bug will still manifest
unless someone finds a way to create the same conditional formatting rule
multiple times.  And example of such a change could be introducing something
into each instance of the formula that doesn't change the result of the
formula, like IF(1=1,"","").  Each time you need this, you could simply change
1=1 to 2=2 or 3=3 and so on.

Of course, that is only meant as a short term workaround and a patch would be
preferred.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200329/761b251a/attachment.htm>