SpreadsheetControl.VisibleRangeChanged Event

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

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v20.1.dll

Declaration

public event VisibleRangeChangedEventHandler VisibleRangeChanged
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).

Implements

DevExpress.XtraSpreadsheet.ISpreadsheetControl.VisibleRangeChanged
See Also