SpreadsheetControl.VisibleRangeChanged Event

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

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v20.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public event VisibleRangeChangedEventHandler VisibleRangeChanged

VB.NET

Public Event VisibleRangeChanged As VisibleRangeChangedEventHandler

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