Skip to main content

SpreadsheetControl.AfterFillRange Event

Occurs after a cell range was automatically filled with data based on values in the source range.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

public event AfterFillRangeEventHandler AfterFillRange

Event Data

The AfterFillRange event's data class is AfterFillRangeEventArgs. The following properties provide information specific to this event:

Property Description
OperationType Gets the type of the fill operation a user performed over a cell range.
SourceRange Returns a cell range based on which a user filled cells in the target range.
TargetRange Returns a cell range that a user filled with data.

Remarks

Handle the AfterFillRange event to perform any actions after the AutoFill operation was performed for cells. This event allows you to obtain the source and resulting ranges, and determine whether a user copied source cells or filled cells with data based on values in the source range.

To cancel the fill operation for a cell range, handle the SpreadsheetControl.BeforeFillRange event and set its Cancel parameter to true.

See Also