We have a possibility to use dataFormat within Conditional Formatting to change value's color in the cell.
Apache POI support it but Spreadsheet is not.
Describe the solution you'd like
A good solution which I would to apply is to use dataFormat as string value as: #,##0_);[Red](#,##0) - which means if value less than zero then apply red color and parentheses.
Describe alternatives you've considered
The only solution for this time is Java API approach (e.g.: SheetConditionalFormatting.java). It's good but with dataFormat it will be more laconically.
Describe your motivation
We have a possibility to use
dataFormatwithin Conditional Formatting to change value's color in the cell. Apache POI support it but Spreadsheet is not.Describe the solution you'd like
A good solution which I would to apply is to use
dataFormatas string value as:#,##0_);[Red](#,##0)- which means if value less than zero then apply red color and parentheses.Describe alternatives you've considered
The only solution for this time is Java API approach (e.g.: SheetConditionalFormatting.java). It's good but with
dataFormatit will be more laconically.Additional context
Link to related issue: https://github.com/vaadin/flow-components/issues/6819