The behaviour of insert-column on an area with conditional formatting
depends on conditional formatting present in other parts of the sheet.
Sometimes it updates correctly, sometimes it does not.
localc 22.214.171.124 as supplied in Linux Mint 20 (Ulyana)
Steps to Reproduce:
Load to-be-attached cf1.ods. The colours in the right-hand block
come from conditional formatting based on the block of values to
the left using relative cell references.
Insert a new column before column C and notice that the coloured
block moves to the right correctly. This works fine.
Now load cf2.ods. It's the same file, except that c7:h9 has been copied
Insert a new column before column C and notice that this time the conditional
formatting breaks for h7:i9. This is because the conditional formatting
still refers to c7:d9 instead of d7:e9
Before the column insert, the original and the copy have the same conditional
formatting. They also do afterwards (ie., one line in the manage-conditional-
formatting dialog) but they need to be different (two lines) because the
relative references need to be updated differently.
With cf2.ods, the conditional formatting ends up referring to c7:d9.
As a consequence, h7:h9 is displayed wrong.
With cf2.ods, the conditional formatting should end up referring to d7:e9.
h7:i9 should look like g7:h9 did before the insert.
User Profile Reset: No
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Created attachment 162948 [details]
Insert before column C works fine with this file.
Created attachment 162949 [details]
Insert column before column C fails with this file.
Build ID: d851a02df57ab378ed0cc6d9362516de09c3279c
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Regression introduced by:
author Kohei Yoshida <firstname.lastname@example.org> 2014-05-13 12:35:24 -0400
committer Kohei Yoshida <email@example.com> 2014-05-13 12:37:14 -0400
commit a93bb27aa46c84410c8848a6118d5d63d47be92c (patch)
parent 49bf3a1f5f38cdf259101b15a19d546b32151463 (diff)
fdo#78402: Adjust references of validity entries as appropriate.
Bisected with: bibisect-43max
Adding Cc: to Kohei Yoshida
@Dennis, @Luboš, I thought you might be interested in this issue