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.VisibleRangeChanged Event

Occurs after the visible cell range was changed in the Spreadsheet control.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

#Declaration

public event VisibleRangeChangedEventHandler VisibleRangeChanged

#Event Data

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

Property Description
Range Gets the cell range that is currently visible in the Spreadsheet control.
UnfrozenRange Gets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.

#Remarks

The VisibleRangeChanged event occurs in the following cases:

  • when you resize the Spreadsheet control;

  • when you create or load a workbook;

  • when you add or remove a worksheet;

  • when you switch between worksheets;

  • when you scroll a worksheet;

  • when you zoom a worksheet;

  • when you freeze / unfreeze rows and columns in a worksheet.

Handle the VisibleRangeChanged event to obtain actual values for the visible cell range (Range) and visible unfrozen range (UnfrozenRange).

See Also