Describe the new feature
Hello.
I would like to suggest extending the conditional formatting feature to support Excel-like cell references and an explicit range to which the formatting should be applied.
For example, I imagine adding an Apply to column to the right side of the existing conditional formatting dialog:
| Condition |
Apply to |
| expr:AND($C2<>"",$E2="") |
A:E |
The Apply to column could specify the columns to which the formatting rule should be applied, such as A:E.
The existing Condition column could support an expr: prefix for expression-based conditions, in order to distinguish them from the existing conditions using =. For example:
expr:AND($C2<>"",$E2="")
In this example, the formatting would be applied to columns A through E when column C is not empty and column E is empty for the corresponding row.
I forked the project and tried implementing this feature myself. My initial idea was to modify src/CondFormatManager.ui to add the Apply to column and use the expr: prefix for these expression-based conditions, but I found the implementation more difficult than I expected and was unable to complete it.
Does this feature exist in another product or project? Please provide a link
No response
Do you have a screenshot? Please add screenshots to help explain your idea.
No response
Reactions are currently unavailable
Describe the new feature
Hello.
I would like to suggest extending the conditional formatting feature to support Excel-like cell references and an explicit range to which the formatting should be applied.
For example, I imagine adding an Apply to column to the right side of the existing conditional formatting dialog:
The Apply to column could specify the columns to which the formatting rule should be applied, such as A:E.
The existing Condition column could support an expr: prefix for expression-based conditions, in order to distinguish them from the existing conditions using =. For example:
expr:AND($C2<>"",$E2="")
In this example, the formatting would be applied to columns A through E when column C is not empty and column E is empty for the corresponding row.
I forked the project and tried implementing this feature myself. My initial idea was to modify src/CondFormatManager.ui to add the Apply to column and use the expr: prefix for these expression-based conditions, but I found the implementation more difficult than I expected and was unable to complete it.
Does this feature exist in another product or project? Please provide a link
No response
Do you have a screenshot? Please add screenshots to help explain your idea.
No response