Worksheet.ScrollTo(CellRange) Method
In This Article
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 |
---|---|---|
scrolled |
Cell |
A Cell |
#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