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: [email protected]
Reporter: [email protected]
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.