GetCell

GetCell is a text function that returns a data value from a grid. The row, column, and page arguments apply to the grid.

Note:

When referencing a cell containing Planning, GetCell returns a string value instead of a number.

The function syntax is:

<<GetCell("GridName", Row, Column, Page)>>

Argument	Description
GridName	The name of a grid or the Current keyword.
Row	Numeric value representing the row number of the grid. The first row in a grid has an index of one, the second row has an index of two, and so forth. The Current keyword can also be used.
Column	A letter representing the column of the grid. The first column in a grid has an index of A, the second column has an index of B, and so forth.
Page	A numeric value representing the page dimension index of the grid. The first page dimension in a grid has an index of one, the second page dimension has an index of two, and so forth.

Note:

The Current keyword can be used in any of the parameters. Doing so, make the function more dynamic. For information and examples, see Current / Cur Keyword.

Note:

If the row or column parameters refer to a segment that expands, the top-left expanded cell is used. You can refer to any expanded cell using the “range” notation.

Example

You set up a grid to show the grand total of several quarter’s net income. You want to display this value in a text box that contains an executive summary of the report.

The following example shows a report with the value in the cell that is in row 21, column B of a grid and is on the first page dimension. The syntax is:

The grand total for the period was <<GetCell("mygrid",21,B,1)>>.

Tip:	To view result-time rows and columns, select View, then Row & Column Headers Web Preview, then preview the report in Workspace by clicking the Web Preview button.

Note:

This function only supports the Current keyword when used in a grid cell; not in a text box object, header, footer or otherwise. For information and examples, see Current / Cur Keyword.