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

            Bug ID: 158187
           Summary: [feature request] copy rules from Manage < Conditional
                    Formatting
           Product: LibreOffice
           Version: 7.6.2.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: mattia....@gmail.com

Description:
Issue was born here
[https://ask.libreoffice.org/t/conditional-formatting-multiple-range/98131]
originally.

Long story short: conditional rules cannot have multiple ranges.
Easiest way to overcome this problem is to simply copy rules, then change cell
range manually, case-by-case;
Unfortunately when you copy the conditional formatting*, LO does not create a
new rule but "increases" the cell range** in existing rule.

*by copying the cell with the conditional formatting, Edit > Paste Special,
uncheck “Paste all” and uncheck all boxes in the Selection area except Formats;
**maybe this is a desired behaviour since condition is the same...

With a simple "Copy" button in the conditional formatting, we can fix this
issue.

---
a simple mockup is attached below.


Steps to Reproduce:
try to copy a conditional formatted rule 

Actual Results:
you cannot

Expected Results:
you can


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: it-IT (en_GB.UTF-8); UI: en-GB
7.6.2-3
Calc: CL threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to