Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetControl.AfterFillRange Event

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

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.2.dll

NuGet Package: DevExpress.Wpf.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