Bug 138695 - Remember the last choice in conditional formatting
Summary: Remember the last choice in conditional formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
Reported: 2020-12-06 16:22 UTC by romain2boss
Modified: 2021-04-06 11:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description romain2boss 2020-12-06 16:22:52 UTC
In Conditional Formatting window it would be handy to be able to dupplicate an existing rule in order to not start from scratch when you want similar rules applyed to same range or to several ranges.
Comment 1 Roman Kuznetsov 2020-12-26 21:28:49 UTC
Let's ask UX-team

I personally have no opinion here
Comment 2 S.Zosgornik 2020-12-27 20:11:29 UTC
Don't see the workflow for adding new rules comprehensive.
Only convenient in rare use case for adding a hole bunch of similar rules like is cell value =1 =2 =3 ...

-1 from me
Comment 3 Heiko Tietze 2021-01-11 05:56:43 UTC
Scenario might be
<Cell value is> <Contains> <"Alpha"> Apply Style <Style_Alpha>
<Cell value is> <Contains> <"Beta"> Apply Style <Style_Beta>
etc. where scrolling down to "Contains" is annoying. 

But I wouldn't introduce a Copy or Duplicate function in addition to Add. We could just remember the last setting and take it into the next condition.

This use case is about within one configuration. If you reopen the dialog for another cell or if you have closed the application it would start from zero again. So what's your use case, Romain?
Comment 4 romain2boss 2021-04-01 15:25:58 UTC
The main idea is to save time to be more efficient when using conditional formats. The main use case is what you describe: It is painful to have to create 10 conditional formating rules choosing range, format and condition with only a minor change between them, especially when you have to type formulas as conditions. Many clicks, few added value.

I wich I can select one or many existing rule(s) and dupplicate it/them to change only parts of the rule(s). This way I can create by hand one rule, complex or simple, and after dupplicating it change only a part of the condition and/or a part of its format (I might want to change background color only but keep borders, font weight and font family as per previous rule). Setting condition can also take some times, looking for the right option of the right menu evry time.

I also thought about being able to copy and paste a rule in order to be more efficient when using multiple sheets or files. Today the way of doing it is to copy and paste only format. But I proposed to have a dupplicate button first because this is clearly missing to the two office suites I use, LO being one of them.
Comment 5 Heiko Tietze 2021-04-06 11:10:28 UTC
Let's do it. Copy/paste or duplicate clutter the UI or might not be easy to understand. But if we just pick the choice instead the workflow is a bit less tedious.