Some methods return cell statuses. Cell statuses are numeric codes that are represented by constants in the HFMConstants type library and that provide the following types of status information for a cell:
Transaction status, which indicates the source of a cell’s data. Constants that represent the transaction statuses are listed in Cell Status Constants.
Metadata status, which provides information derived from the attributes of a cell’s dimension members. Constants that represent the metadata statuses are listed in Cell Metadata Status Constants.
Calculation status, which provides information such as whether a cell is locked and whether it requires calculation, consolidation, or translation. Constants that represent the calculation statuses are listed in Cell Calculation Status Constants.
The applicable methods return all three types of statuses within one return value. The return value is a bit-field containing 32 bits, in which the least significant 8 bits store the cell’s transaction status codes, the most significant 10 bits store the cell’s calculation status codes, and the middle bits store the cell’s metadata status codes.
To access a cell’s status codes in VBScript, perform bitwise comparisons with operators such as AND. For example, the calculation status indicating that a cell contains no data is represented by the constant CELLSTATUS_NODATAINTABLE. The following If statement tests whether a cell status includes the “no data” calculation status. In this example, assume that the cell status has been assigned to the lStat variable:
If (CELLSTATUS_NODATAINTABLE And lStat) Then