Back to Devexpress

SpreadsheetControl.VisibleRangeChanged Event

windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontrol-76e8c05a.md

latest2.5 KB
Original Source

SpreadsheetControl.VisibleRangeChanged Event

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

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.XtraSpreadsheet.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

csharp
public event VisibleRangeChangedEventHandler VisibleRangeChanged
vb
Public Event VisibleRangeChanged As VisibleRangeChangedEventHandler

Event Data

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

PropertyDescription
RangeGets the cell range that is currently visible in the Spreadsheet control.
UnfrozenRangeGets 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

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.XtraSpreadsheet Namespace