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
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.
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.
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.
See Also