LabeledCellText retrieves the textual content from a Financial Management database connection through their ADM driver.
The syntax:
LabledCellText(“GridName”, Row, Column, Page, “Label”, [Attachments], [MemberOverride])
Where:
GridName - The name of a grid. This value must be enclosed in quotation marks.
Row: - A 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 forth. The ALLROWS and CUR keywords are supported.
Column or Col: - 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. The ALLCOLS and CUR keywords are supported.
Page: - A 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 forth.
Label: - Identifies the Financial Management cell label to which the desired cell texts (and optionally attachments) correspond. This value must be enclosed in quotation marks.
Attachments: - (optional) A TRUE or FALSE value indicating whether attachments associated with the cell text should be retrieved.
MemberOverride: - (optional) A string of comma separated dimensions and corresponding member selections that override the active POV. See “CellText function with Member Override” for details.
Examples:
LabeledCellText("Grid1", CUR, A, 1, "MATURITYDATE")
LabeledCellText("Grid1", 3, CUR, 1, "RATING", TRUE)
LabeledCellText("Grid1", 3, CUR, 1, "RATING", TRUE, Year=Quarter1)