Row and Column format by wildcard

[Radu Cantor]

It would be nice to be able to apply row or column format in grids using wildcards in the condition

[Scott Wiltshire]

Wildcards in the condition? → You mean if the condition is based on a text value? (as can’t see how this would work for numeric conditions).

e.g. do you mean like this?

"columnFormat": {
      "Column to Format": [
        {
          "dataColumn": "ColumnToMatch",
          "condition": "=",
          "value": "*matchString*",
          "className": "kpi-green"
        }
      ]
}

‌

I assumed when I read the title you were requesting specifying the column or row by wildcard as opposed to by index or by name. That would be really useful IMHO as often you have a report where columns could be dynamic or there could be lots of columsn with similar bnames and a matching pattern.

e.g.

"columnFormat": {
      "$<<TM1.Year.Year>>-M??": [
        {
          "className": "kpi-green"
        }
      ]
}

‌