TdxSpreadSheetTableView.FillData(string,string) Method

Populates a specified cell range with values from a source cell range. Accepts each cell range as a reference (in the A1 or R1C1 format depending on the OptionsView.R1C1Reference) property value).

Declaration

procedure FillData(const ASourceArea: string; const ATargetArea: string); overload;

Parameters

Name	Type	Description
ASourceArea	string	A reference to the source cell range.
ATargetArea	string	A reference to the target cell range.

Remarks

Call the FillData procedure to copy content of the ASourceArea cell range into the ATargetArea cell range.

Note

A FillData call clears the source cell range (ASourceArea) if it intersects with the target cell range (ATargetArea) or if these cell ranges are not adjacent.

Other FillData Procedures

FillData(cxClasses.TcxDirection,System.Integer)

Populates a target cell range defined by the selected cell range, a specified direction, and number of rows/columns. Uses the selected cell range as the source.

FillData(System.String,cxClasses.TcxDirection,System.Integer)

Populates a target cell range defined by the source cell range (in the A1 or R1C1 format), direction, and number of rows/columns.

FillData(System.Types.TRect,System.Types.TRect)

Populates a specified cell range with values from a source cell range. Accepts each cell range as a rectangle defined by four cell positions (in indexes).

FillData(System.Types.TRect,cxClasses.TcxDirection,System.Integer)

Populates a target cell range defined by the source cell range, direction, and number of rows/columns. Accepts the source cell range as a rectangle defined by four cell positions (in indexes).