[Libreoffice-ux-advise] [Bug 158187] [feature request] copy rules from Manage < Conditional Formatting (to apply it to a different range instead of extending it)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
I'm not convinced by the Copy button idea. It's not clear what you copy
(condition type, value, style) and what it actually means (usually to store in
the clipboard for pasting, here to duplicate). Excel has a button "Duplicate
Rule".

But I wonder if users could expect the range in CF to be adjusted to the
selection when pasted. Workflow would be to create the rule/s for F5:F17, to
copy, select the range F20:32, and inserting the format adjusts the range
accordingly.

Excel provides the paste option "Merge Conditional Formatting" but that
overwrites the values too (don't understand why). But under Paste > Other Paste
Options there is a "Formatting" option which exactly does what I have in mind.
(However, only once. Everything breaks when applied again to 2022 although CF
is inserted properly.)

-- 
You are receiving this mail because:
You are on the CC list for the bug.