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

TdxSpreadSheetTableView.SetCellData(Integer,Integer,Variant,TdxSpreadSheetFormulaErrorCode) Method

Populates a cell at the specified position with a value and an error code.

#Declaration

Delphi
procedure SetCellData(const ARow: Integer; const AColumn: Integer; const AValue: Variant; const AErrorCode: TdxSpreadSheetFormulaErrorCode);

#Parameters

Name Type
ARow Integer
AColumn Integer
AValue Variant
AErrorCode TdxSpreadSheetFormulaErrorCode

#Remarks

This procedure is accessible via the IdxSpreadSheetViewData interface and is called by the ExpressSpreadSheet formula engine to populate a cell with a calculated formula expression result and a code from the error codes listed in the TdxSpreadSheetFormulaErrorCode type description.

The SetCellData procedure creates a cell object at the intersection of the row and column whose zero-based indexes are passed as the ARow and AColumn parameters and/or populates it with a value passed as the AValue parameter. Additionally, the procedure sets the AErrorCode parameter value as the cell’s error status. Normally, a cell has no error (the ecNone code) if its formula expression is correctly parsed and calculated, or there is no formula expression associated with the cell.

See Also