Created attachment 89371 [details]
simple calc document showing the erroneous behaviour.
The conditional formatting (formula type) of source sheet is copied to the destination sheet, but the contents of the conditional formatting formula still refers to the source sheet.
Steps to reproduce:
1. create a simple conditional formatting on Sheet1.A1: =$C1="x"
2. copy Sheet1 as Sheet2 -> conditional formatting on Sheet2.A1: =$C1="x"
3. insert a column B in Sheet1
4. conditional formatting on Sheet2.A1 is now WRONG: =$D1="x"
The copied sheet conditional formatting formulas refer to the wrong sheet
The copied sheet conditional formatting formulas must refer to the copied sheet and not to the source shett.
Operating System: Ubuntu
Version: 18.104.22.168 release
Hi oudeis69, thanks for reporting.
Are you sure, there are not both sheets selected when inserting the column?
I can not reproduce the issue if only Sheet1 is selected.
The two sheets weren't selected.
How can I be so sure? Easy: the (visible) contents of row C in sheet2 is *not* moved...
My explanation (and description) of the bug was not clear enough...
The problem is with the conditional formatting only when using, e.g.:
"Formula is" $C1="x"
My wordings were not "correct" in the bug submission...
Fixed with bug 61946
*** This bug has been marked as a duplicate of bug 61946 ***