GetCellInfo

Returns various types of information for the specified cell, such as the cell’s dimension members and calculation status.

Tip:	To return cell information as an XML string, use GetCellInfoAsXML.

Syntax

<HFMwDataGrid>.GetCellInfo lRow, lColumn, pvarbstrProcessUnit, pvarbstrPOVDetail, pvarbstrView, pvarbstrCalcStatus, pvarbstrProcessLevel, pvarbstrCellStatus, pvarbstrCellSecurityAccess, pvarbstrDisplayedData, pvarbstrFullResolutionData, pvarbstrStoredData

Argument	Description
lRow	The index (0-based) that identifies the cell’s row. Input argument. Long subtype.
lColumn	The index (0-based) that identifies the cell’s column. Input argument. Long subtype.
pvarbstrProcessUnit	Returns the labels of the dimension members that the cell’s process unit consists of. The labels are delimited by commas. Tip: Process units are described in About Process Units. Output argument.
pvarbstrPOVDetail	Returns the labels of the cell’s Account, Intercompany Partner, and Custom 1-4 dimension members. The labels are delimited by commas. Output argument.
pvarbstrView	Returns the label of the cell’s View dimension member. Output argument.
pvarbstrCalcStatus	Returns a string description of the cell’s calculation status. Output argument.
pvarbstrProcessLevel	Returns a string description of the cell’s process management review level. Output argument.
pvarbstrCellStatus	Returns a string description of the cell’s status. Output argument.
pvarbstrCellSecurityAccess	Returns a string description of the cell’s security access rights. Output argument.
pvarbstrDisplayedData	Returns the displayed data. Note: The data returned is rounded to the number of decimal places specified for the cell’s account, and includes the user’s thousands separator preference. Output argument.
pvarbstrFullResolutionData	Returns the full resolution data. Note: The data returned includes the user’s thousands separator preference. Output argument.
pvarbstrStoredData	Returned the stored data. Output argument.

Example

The following function takes an HFMwDataGrid object and the row and column indexes that identify a cell in the object and returns the string that describes the cell’s calculation status.

Function getCellCalcStatus(cDataGrid, lRow, lCol)
Dim sProcessUnit, sPOVDetail, sView, sCalcStatus, sProcessLevel
Dim sCellStatus, sSecurityAccess, sDisplayedData
Dim sFullResolutionData, sStoredData
cDataGrid.GetCellInfo lRow, lCol, sProcessUnit, sPOVDetail, _ 
sView, sCalcStatus, sProcessLevel, sCellStatus, _ 
sSecurityAccess, sDisplayedData, sFullResolutionData, _ 
sStoredData
getCellCalcStatus = sCalcStatus
End Function