windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontrol-2ca5b0d2.md
Occurs after a cell range was automatically filled with data based on values in the source range.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.XtraSpreadsheet.v25.2.dll
NuGet Package : DevExpress.Win.Spreadsheet
public event AfterFillRangeEventHandler AfterFillRange
Public Event AfterFillRange As AfterFillRangeEventHandler
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. |
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