Bug 167396 - CF - Conditional formatting: wrong reference when copying
Summary: CF - Conditional formatting: wrong reference when copying
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-07-06 02:13 UTC by Michael
Modified: 2025-07-06 10:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
copy of sheet, that's referenz in description (40.92 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-07-06 02:15 UTC, Michael 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael 2025-07-06 02:13:05 UTC 
Description:
Conditional formatting: wrong reference in Formula when copying (columns) and paste (columns). The references are not absolute.

Repro:
Select Col K:L 
Copy
Select Col M:P
Paste content: only formats 

Actual Results:
Col K with CF-Formula =MITTELWERT(K1:K10000)
Col L with CF-Formula =MITTELWERT(L1:L10000)
Col M with CF-Formula =MITTELWERT(K1:K10000)
Col N with CF-Formula =MITTELWERT(L1:L10000)
Col O with CF-Formula =MITTELWERT(K1:K10000)
Col P with CF-Formula =MITTELWERT(L1:L10000)


Expected Results:
Col K with CF-Formula =MITTELWERT(K1:K10000)
Col L with CF-Formula =MITTELWERT(L1:L10000)
Col M with CF-Formula =MITTELWERT(M1:M10000)
Col N with CF-Formula =MITTELWERT(N1:N10000)
Col O with CF-Formula =MITTELWERT(O1:O10000)
Col P with CF-Formula =MITTELWERT(P1:P10000)


Possible connection, but it is not a duplicate:
Bug 126327 - Conditional formatting: wrong reference when copying the table


Linux Mint 21.3 Virginia (Flatpak)
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded


Can't open with old, because another Bug (to many Columns, CF lost References):
Linux Mint 21.3 Virginia (System Install)
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.10
Calc: threaded


key words: FORMATTING "Conditional formatting" reference formula



Steps to Reproduce:
Select Col K:L 
Copy
Select Col M:P
Paste content: only formats 

Actual Results:
Col K with CF-Formula =MITTELWERT(K1:K10000)
Col L with CF-Formula =MITTELWERT(L1:L10000)
Col M with CF-Formula =MITTELWERT(K1:K10000)
Col N with CF-Formula =MITTELWERT(L1:L10000)
Col O with CF-Formula =MITTELWERT(K1:K10000)
Col P with CF-Formula =MITTELWERT(L1:L10000)

Expected Results:
Expected Results:
Col K with CF-Formula =MITTELWERT(K1:K10000)
Col L with CF-Formula =MITTELWERT(L1:L10000)
Col M with CF-Formula =MITTELWERT(M1:M10000)
Col N with CF-Formula =MITTELWERT(N1:N10000)
Col O with CF-Formula =MITTELWERT(O1:O10000)
Col P with CF-Formula =MITTELWERT(P1:P10000)


Reproducible: Always


User Profile Reset: No

Additional Info:

Linux Mint 21.3 Virginia (Flatpak)
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
Comment 1 Michael 2025-07-06 02:15:24 UTC 
Created attachment 201676 [details]
copy of sheet, that's referenz in description
Comment 2 m_a_riosv 2025-07-06 10:45:54 UTC 
In the sample file:
· The color scale conditions has '=AVERAGE(#REF!)' as formula.
· And I don't think INDIRECT(\"R[-1]C\";0) is a valid formula.