Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Worksheet.ScrollTo(CellRange) Method

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

void ScrollTo(
    CellRange scrolledAreaTopLeftCell
)

#Parameters

Name Type Description
scrolledAreaTopLeftCell CellRange

A CellRange 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.

    ScrollToHiddenColumnsAndRowsRange

  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.

    ScrollToFrozenColumnsAndRowsRange

See Also