CellText
CellText is a text function that retrieves the textual content from the following database connections:
The row, column, and page arguments apply to the intersection in a grid that contains the linked text or note.
Syntax:
<<CellText("GridName", Row, Column, Page)>>
CellText can also provide an override of the grid’s "natural" point of view (POV) to a member selection when a cell does not exist in a grid.
Syntax:
<<CellText("GridName", Row, Column, Page, MembeOverride)>>
See CellText Using MemberOverride for details.
| Argument | Description |
|---|---|
|
GridName |
Name of a grid. This value must be enclosed in quotation marks |
|
Row |
Numeric value representing the row number of the grid. The first row in a grid has an index of 1, the second row has an index of 2, and so on. |
|
Column |
Letter that represents 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 on. |
|
Page |
Numeric value representing the page dimension index of the grid. The first page dimension in a grid has an index of 1, the second page dimension has an index of 2, and so on. |
|
MemberOverride |
String of dimensions and corresponding member selections that override the |
|
AllRows/AllCols |
Keywords that allow for an all row or column reference. See CellText Using AllRows/AllCols. |
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:
Create a report with linked text in the cell that is in row 21, column B of a grid and that is on the first page dimension.
<<CellText("mygrid",21,B,1)>>
Tip:
To view result-time rows and columns, select View, then Row & Column Headers in Web Preview, and then preview the report by clicking Web Preview.
Note:
CellText only supports the Current keyword when used in a grid cell; not in a text box object, header, or footer. See Using the Current/Cur Keyword in a Text Function.
Note:
If no textual commentary exists for a cell intersection that the CellText function references, a URL for the first cell file attachment in the cell is displayed. To list the cell file attachments, use the ListofCellDocuments text function.