[Libreoffice-bugs] [Bug 139784] New: Conditional formatting over multiple tabs does work but can't be saved

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139784
           Summary: Conditional formatting over multiple tabs does work
                    but can't be saved
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rob at famjasper.nl

Description:
If 

Steps to Reproduce:
1. Create a file with in Sheet1 entries (e.g. A-F) vertical in column A
2. Create sheet2 with some entries in column A
3. Set conditional foor sheet1 to "is Duplicate" for range
"A1:A9;$Sheet2:A1:$Sheet2:A100"
4. Save
5. In the popup the range is set to "A1:A9;A1:A100" (ERRONIOUS)
6. The condition works as espected: Cells in Sheet1 with values that occur in
sheet 2 are formatted.
7. Save the file

Actual Results:
Apon re-opening the formatting only works for sheet1

Expected Results:
Range should stay as specified
Formatting should still be present


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: nl-NL (nl_NL.UTF-8); UI: en-US
Calc: threaded

-- 
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/20210120/66c9a527/attachment.htm>