Grid Format, add “contain”, “not contain”, “starting with” and “ending with” conditions

When evaluating the row and column format for string values only “==” and “!=” is used. These conditions require the datapoint to fully match the “value” in the format. More flexibility is required when evaluating strings.

A new options of “contain”, “not contain”, “starting with” and “ending with” for the “condition” setting for row and column formatting of grids. Selecting “contains” would evaluate the datapoint. If the datapoint contains the “value”, the “className” format is applied to the datapoint. The opposite would apply to “not contain” condition. If the datapoint does NOT contain the “value” then the “className” is applied to the datapoint. The condition “stating with” would evaluate the datapoint with the starts with the “value”. The condition “ending with” would evaluate the datapoint ends with the “value'.

For numeric value the above conditions would evaluate the numeric value as a string.

Benefits:

Allow more flexibility to formatting strings, especially where html mark up is used in the value of the datapoint.
Functionality exist in excel/tm1web.

‌

Comments (1)