IdxSpreadSheetCellData.AsError Property

Returns a cell value calculation’s error status.

Declaration

property AsError: TdxSpreadSheetFormulaErrorCode read;

Property Value

Type
TdxSpreadSheetFormulaErrorCode

Remarks

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

• No formula expression is associated with a cell (that is, the AsFormula property returns nil);

• The cell’s formula expression is parsed and calculated without errors.

The AsError property returns a code from the error codes list if an error occurs on parsing or evaluating a formula expression. The TdxSpreadSheetFormulaErrorCode type description lists detailed information on all error codes.