Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetCustomFormula Properties

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