TdxSpreadSheetFormula Properties

Stores a parsed formula expression within a cell object.

Name	Description
ActualErrorCode	Inherited from TdxSpreadSheetCustomFormula.
ActualValue	Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula.
Anchor	Returns the coordinates of the formula expression’s anchor cell. Inherited from TdxSpreadSheetCustomFormula.
AnchorColumn	Returns a zero-based index of the column to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.
AnchorRow	Returns the zero-based index of the row to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.
ArrayFormulaArea	Returns the area occupied by the array formula result. Inherited from TdxSpreadSheetCustomFormula.
ArrayFormulaSize	Returns the dimensions (in cells) of an area occupied the array formula result. Inherited from TdxSpreadSheetCustomFormula.
AsText	Returns the parsed formula expression as a text string. Inherited from TdxSpreadSheetCustomFormula.
Cell	Returns the cell object to which the formula belongs.
Controller	Provides access to the formula controller that handles the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
ErrorCode	Returns an error code indicating the parsed formula expression’s evaluation or calculation state. Inherited from TdxSpreadSheetCustomFormula.
ErrorIndex	Returns the index of the first unrecognized character in the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula.
FormatSettings	Provides access to the formula expression’s source text string parsing format settings. Inherited from TdxSpreadSheetCustomFormula.
IsArrayFormula	Specifies if the formula expression’s calculation result is an array. Inherited from TdxSpreadSheetCustomFormula.
Iteration	Inherited from TdxSpreadSheetCustomFormula.
ResultValue	Provides access to the properties and methods related to parsing the formula expression’s source text. Inherited from TdxSpreadSheetCustomFormula.
SourceText	Specifies the source text string of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
Tokens	Provides access to the token tree of the parsed formula expression. Inherited from TdxSpreadSheetCustomFormula.
Value	Returns the formula expression’s calculation result. Inherited from TdxSpreadSheetCustomFormula.
View	Provides access to the worksheet or Grid View to which the formula expression belongs. Inherited from TdxSpreadSheetCustomFormula.