We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

[Feature request] Expanding options with conditional formatting

Resolved
Accobat Development asked on January 17, 2024

Hey dear FlexMonster team,
Our customers love what your conditional formatting. Because of this, some of them have a feature request to expand the format options, if possible.
 
As a reminder, these are the current options:
 

 format: {
    backgroundColor: string,
    color: string,
    fontFamily: string,
    fontSize: string
  }

Some of the most common requests we get are:
 

  1. String to prepend or append
    1. E.g. "if value < 0, append ⚠"
    2. [-500 ⚠]
  2. Bolded value
  3. Italicized value
  4. Perhaps custom CSS/style addition? Similar to cell.style in customizeCell()
    1. This would actually make most of the above possible without extra work on your part

 
Br.
Jonas

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 18, 2024

Hello Jonas,

Thank you for reaching out to us.

Our team is happy to hear that your customers enjoy our conditional formatting feature!
We want to explain that the format object also supports setting the fontStyle and fontWeight properties when setting the condition through the code. For example:

format: {
  fontStyle: "italic",
  fontWeight: "bold"
}

Also, you can use the customizeCell function along with the conditional formatting to use the mentioned cell.style property. The idea is to use the conditional format id from the data.conditions value and apply the further customization. 
You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/8hwLk0g4/

Please let us know if it works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Public
Accobat Development January 22, 2024

Hello again,
 
I was unfamiliar that cells that meet conditions will have them added to their cellData. This makes our request functionally possible without much work required. Thank you very much, we are satisfied with this solution! 🙂 
 
Br
Jonas

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 25, 2024

Hello Jonas,

Thank you for the feedback!

We are glad to hear that the solution works for you.

Kind regards,
Nadia

Please login or Register to Submit Answer