You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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.Additional context
Link to related issue: #6819
The text was updated successfully, but these errors were encountered: