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

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

Declaration

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.