https://bugs.documentfoundation.org/show_bug.cgi?id=167396
Bug ID: 167396
Summary: CF - Conditional formatting: wrong reference when
copying
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
