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

TdxSpreadSheetCell.AsError Property

Specifies the cell object’s error status.

#Declaration

Delphi
property AsError: TdxSpreadSheetFormulaErrorCode read; write;

#Property Value

Type
TdxSpreadSheetFormulaErrorCode

#Remarks

This property returns ecNone if one of the following conditions is met:

  • The cell object has no associated formula expression (that is, the AsFormula property returns nil);

  • The associated formula expression is parsed and calculated without any errors.

If an error occurs on parsing or evaluating a formula expression, the AsError property returns a corresponding code from the error codes list detailed in the TdxSpreadSheetFormulaErrorCode type description.

This property is accessible via the IdxSpreadSheetCellData interface to provide uniform access to the formula expression error status of cells in ExpressSpreadSheet and ExpressQuantumGrid Views.

Note

Use the DataType property to identify the cell object’s actual value type.

See Also