Worksheet.ScrollTo(Range) Method

Scrolls the worksheet to the top-left cell of the specified range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

void ScrollTo(
    Range scrolledAreaTopLeftCell
)

VB.NET

Sub ScrollTo(
    scrolledAreaTopLeftCell As Range
)

Parameters

Name	Type	Description
scrolledAreaTopLeftCell	Range	A Range object to the top-left cell of which the worksheet must be scrolled.

Remarks

When you scroll a worksheet to the specified cell, some special cases can occur.

1. A cell to which you wish to scroll the worksheet is located at the intersection of:

   • a hidden row and visible column. In this case, the workbook will be scrolled to a cell at the intersection of the specified column and the first unhidden row below the specified row.
   • a visible row and hidden column. In this case, the workbook will be scrolled to a cell at the intersection of the specified row and the first unhidden column to the right of the specified column.
   • a hidden row and column. In this case, the workbook will be scrolled to a cell at the intersection of the first unhidden row below the specified row and the first unhidden column to the right of the specified column.

   

2. A cell to which you wish to scroll the worksheet is located at the intersection of:

   • a frozen row and unfrozen column. In this case, the workbook will be scrolled to a cell at the intersection of the first row of the scrollable area and the specified column.
   • an unfrozen row and frozen column. In this case, the workbook will be scrolled to a cell at the intersection of the specified row and the first column of the scrollable area.
   • a frozen row and column. In this case, the workbook will be scrolled to a top-left cell of the scrollable area.