row
Returns the row index of the cell currently referenced by a 'Format' expression script. For example, if you specify a 'Text Color' expression in the 'Format' dialog box for a detail cell in a table, you can use the row property within the script to obtain the index of the row. (The index will change as the expression is evaluated in turn for each detail cell in the column.) This, together with table array and the col property allow you to construct relative references to other cells in the table.
Example
The script below can be used in a 'Text Color' or 'Fill Color' expression to set color formatting on a table detail cell. It assigns a red color if the value in the cell is less than the value of the same cell in the row above, and assigns a green color otherwise.
if (row > 1) {
if (value < table[row-1][col]) {
[255,0,0]
}
else {
[0,255,0]
}
}
See Also
table, for more information about the 'table' array.
Accessing Data in Different Row or Column ('row'/'col'), for further information.
Table Properties, for general information about the Table component.
| << col | © 1996-2013 InetSoft Technology Corporation (v11.5) | cellFormat >> |