Worksheet.ScrollToRow(Int32) Method

Scrolls the worksheet to the specified row.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

void ScrollToRow(
    int rowIndex
)

VB.NET

Sub ScrollToRow(
    rowIndex As Integer
)

Parameters

Name	Type	Description
rowIndex	Int32	An integer that is the zero-based index of the row to which the worksheet must be scrolled.

Remarks

If you scroll to a row that is hidden, the worksheet will be scrolled to the first unhidden row below the specified row.

If you scroll to a row that is frozen, the worksheet will be scrolled to the first row of the scrollable area.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ScrollToRow(Int32) method.

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#

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/CS/UDF_Discount/Form1.cs#L43

    #endregion #GetExistingCells
    spreadsheetControl1.ActiveWorksheet.ScrollToRow(0);
}

VB.NET

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/Form1.vb#L42

'            #End Region ' #GetExistingCells
            spreadsheetControl1.ActiveWorksheet.ScrollToRow(0)
        End Sub