Bug 134767 - Conditional Formatting Corrupted by Column Insert
Summary: Conditional Formatting Corrupted by Column Insert
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
4.3 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2020-07-13 02:12 UTC by mwelinder
Modified: 2022-06-02 22:08 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By: Kohei Yoshida

cf1.ods (9.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-13 02:13 UTC, mwelinder
cf2.ods (9.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-13 02:14 UTC, mwelinder

Note You need to log in before you can comment on or make changes to this bug.
Description mwelinder 2020-07-13 02:12:49 UTC
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 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
to a14:f16.

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.

Actual Results:
With cf2.ods, the conditional formatting ends up referring to c7:d9.
As a consequence, h7:h9 is displayed wrong.

Expected Results:
With cf2.ods, the conditional formatting should end up referring to d7:e9.
h7:i9 should look like g7:h9 did before the insert.

Reproducible: Always

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 mwelinder 2020-07-13 02:13:48 UTC
Created attachment 162948 [details]

Insert before column C works fine with this file.
Comment 2 mwelinder 2020-07-13 02:14:42 UTC
Created attachment 162949 [details]

Insert column before column C fails with this file.
Comment 3 Xisco Faulí 2020-07-16 10:48:46 UTC
Reproduced in

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
Calc: threaded
Comment 4 Xisco Faulí 2020-07-16 10:56:32 UTC
Regression introduced by:


author	Kohei Yoshida <kohei.yoshida@collabora.com>	2014-05-13 12:35:24 -0400
committer	Kohei Yoshida <kohei.yoshida@collabora.com>	2014-05-13 12:37:14 -0400
commit a93bb27aa46c84410c8848a6118d5d63d47be92c (patch)
tree f73842e0d78806d9b62980358485b363eb5a3a10
parent 49bf3a1f5f38cdf259101b15a19d546b32151463 (diff)
fdo#78402: Adjust references of validity entries as appropriate.

Bisected with: bibisect-43max

Adding Cc: to Kohei Yoshida
Comment 5 Xisco Faulí 2020-07-16 10:58:09 UTC
@Dennis, @Luboš, I thought you might be interested in this issue
Comment 6 Justin L 2021-11-19 07:02:19 UTC
repro 7.3+