Bug 126327 - Conditional formatting: wrong reference when copying the table
Summary: Conditional formatting: wrong reference when copying the table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2019-07-10 13:57 UTC by mh76d
Modified: 2022-11-24 09:00 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Test-Document (7.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-07-10 14:00 UTC, mh76d

Note You need to log in before you can comment on or make changes to this bug.
Description mh76d 2019-07-10 13:57:38 UTC
Wenn ich eine Tabelle mit einer bedingten Formatierung kopiere, wird die Referenz auf eine andere Tabelle nicht richtig gesetzt: das Dollar-Zeichen wird ignoriert.

Steps to Reproduce:
1. Create a new spreadsheet document
2. Create a new sheet 
3. In Sheet2 set A1 value '2'
4. In Sheet1 set A1 value 'Test'
5. Format->Conditional->Condition
6. Formula is "$Sheet2.$A$1 = 2"
7. Click "Move or copy sheet"
8. Choose "Copy" and "Insert before Sheet1" (not - move to end position -)

Actual Results:
In the new Sheet (Sheet1_2) the formula from the condition references to sheet1, not sheet2 as expected

The formula is "$Sheet1.$A$1 = 2"

Expected Results:
The formula in the new sheet should be "$Sheet2.$A$1 = 2" as in Sheet1, because of the $-sign.

Reproducible: Always

User Profile Reset: No

Additional Info:
When you choose copy - move to end position - it works as expectedVersion:
Build ID: 6.2.5-1
CPU threads: 4; OS: Linux 5.1; UI render: default; VCL: gtk3; 
Locale: en-US (C); UI-Language: en-US
Calc: threaded

Arch Linux
Comment 1 mh76d 2019-07-10 14:00:25 UTC
Created attachment 152709 [details]
Comment 2 mh76d 2019-07-10 14:04:17 UTC
(In reply to mh76d from comment #0)

sorry for german description. Here in english.

> Description:
When I copy a table with conditional formatting, the reference to another table is not set correctly: the dollar sign is ignored.
Comment 3 m_a_riosv 2019-07-11 00:11:45 UTC
Repro, absolute value on sheet name it's not respected.
Version: (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: threaded
Comment 4 Oliver Brinzing 2019-07-12 14:56:20 UTC
was ok in:

Version (Build ID: e183d5b)

broken in:

Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE
Comment 5 Xavier Van Wijmeersch 2020-02-29 13:08:25 UTC
Repro, absolute value on sheet name it's not respected.

Build ID: 9cb07cdca78e2cb1ecff84b7a8e154b23cc2a46d
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 6 Buovjaga 2020-06-09 13:20:06 UTC
Bibisected with Linux 44max to https://git.libreoffice.org/core/+/4fc788312b52678f9d4b658bf235091c55241337%5E!/
fix copy&paste of conditional format between sheets
Comment 7 QA Administrators 2022-06-10 03:33:35 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2022-11-24 08:11:57 UTC
Still repro

Arch Linux 64-bit
Version: (X86_64) / LibreOffice Community
Build ID: 164d717530aff8d2581d0a2ff249f83aabb27502
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 23 November 2022
Comment 9 Stéphane Guillou (stragu) 2022-11-24 09:00:46 UTC
Commit is from 2014, but copying Markus in anyway, we never know!