Download it now!
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 treegraph
 
Reported: 2019-07-10 13:57 UTC by mh76d
Modified: 2020-06-09 13:20 UTC (History)
4 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

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