TdxSpreadSheetTableView.FillData(TRect,TRect) Method

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).

Declaration

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

Parameters

Name	Type	Description
ASourceArea	TRect	The source cell range.
ATargetArea	TRect	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.String,System.String)

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).

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).