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)
Version:
(earliest affected)
4.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Conditional-Formatting
  Show dependency tree / graph
 
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:

Attachments
Test-Document (7.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-07-10 14:00 UTC, mh76d 		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 mh76d 2019-07-10 13:57:38 UTC 
Description:
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: 

6.2.5.2
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]
Test-Document
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: 6.2.5.2 (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 3.6.7.2 (Build ID: e183d5b)

broken in:

Version: 4.4.7.2
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.

Version: 7.0.0.0.alpha0+
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: 7.5.0.0.alpha0+ (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!