[Libreoffice-bugs] [Bug 126327] New: Conditional formatting: wrong reference when copying the table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126327

            Bug ID: 126327
           Summary: Conditional formatting: wrong reference when copying
                    the table
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mh76d at web.de

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190710/c5f07470/attachment.html>