SpreadsheetControl.VisibleRange Property

Gets the cell range that is currently visible in the Spreadsheet control.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Spreadsheet, DevExpress.Wpf.Spreadsheet

Declaration

C#

[Browsable(false)]
public CellRange VisibleRange { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property VisibleRange As CellRange

Property Value

Type	Description
CellRange	Specifies the currently visible cell range.

Remarks

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the VisibleRange property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheetcontrol-examples-e4975/CS/SpreadsheetControl_WPF_Examples/SpreadsheetActions/RowAndColumnActions.cs#L24

// Access the cell range that is currently visible.
CellRange visibleRange = control.VisibleRange;
//Range visibleRange = control.Document.Range.FromLTRB(10, 15, 15, 20);

VB.NET

wpf-spreadsheetcontrol-examples-e4975/VB/SpreadsheetControl_WPF_Examples/SpreadsheetActions/RowAndColumnActions.vb#L23

' Access the cell range that is currently visible.
Dim visibleRange As CellRange = control.VisibleRange
'Range visibleRange = control.Document.Range.FromLTRB(10, 15, 15, 20);