WebDataRocks End User License Agreement (“Agreement”) has been revised and is effective as of April 18, 2024.
The following modifications have been made:
The modified version of WebDataRocks End User License Agreement is available here.
Downloading, installing, and/or continuing to use WebDataRocks after April 18, 2024, constitutes your acceptance of the terms and conditions of the modified version of WebDataRocks End User License Agreement. If you do not agree to any of these terms and conditions, do not download, install, use, or access (or continue to access) WebDataRocks.
Conditional format object is used for defining conditional formatting rules.
Name | Type | Description |
---|---|---|
formula | String | Condition rule. Can include AND , OR , == , != , > , >= , < ,<= , - , + , * , / , isNaN() , !isNaN() . #value is used for referring to the value of the cell in the condition. Example: '#value > 3' . |
format | Object | Style object applied if the cell value meets the condition. Set color value as hex color codes. This is important for exports to PDF and Excel. |
id | Number | optional Identifier in the conditional formatting rule. If id is not specified, the id for the rule is set inside the component automatically. |
row | Number | optional Row index where the condition is applied. |
column | Number | optional Column index where the condition is applied. |
measure | String | optional Measure name to which the condition will be applied. |
isTotal | Boolean | optional If undefined, the condition will affect all cells. If true , the condition affects subtotals and totals cells alone. If false it affects only the regular cells. |
Add conditional formatting rule: