CellValue

CellValue is a text function that returns a data value from cell in a grid.

Syntax:

CellValue("GridName", Row, Column)

Note:

See Parameters for Text Functions for parameter definitions.

Consideration when using CellValue:

If the row or column parameters refer to a segment that expands, all of the cells are returned, separated by commas. You can refer to any expanded cell using the "range" notation.

Example:

Set up a grid to show the net income for several quarters, and display this value in a text box that contains an executive summary of the report.

The grand total for the period was CellValue("mygrid",21,B).

The report is created with the value in the cell that is in row 21, column B of a grid.