All docs
V19.2
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

CellRange.Offset(Int32, Int32) Method

Returns the cell range that is offset by the specified number of rows and columns from the current range.

Namespace: DevExpress.Spreadsheet

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

Declaration

CellRange Offset(
    int rowCount,
    int columnCount
)
Function Offset(
    rowCount As Integer,
    columnCount As Integer
) As CellRange
CellRange Offset(
    int rowCount,
    int columnCount
)
Function Offset(
    rowCount As Integer,
    columnCount As Integer
) As CellRange
CellRange Offset(
    int rowCount,
    int columnCount
)
Function Offset(
    rowCount As Integer,
    columnCount As Integer
) As CellRange

Parameters

Name Type Description
rowCount Int32

An integer that specifies the number of rows by which the cell range should be offset (positive value - range is offset down, negative value - range is offset up, zero - range is not offset vertically).

columnCount Int32

An integer that specifies the number of columns by which the cell range should be offset (positive value - range is offset to the right, negative value - range is offset to the left, zero - range is not offset horizontally).

Parameters

Name Type Description
rowCount Int32

An integer that specifies the number of rows by which the cell range should be offset (positive value - range is offset down, negative value - range is offset up, zero - range is not offset vertically).

columnCount Int32

An integer that specifies the number of columns by which the cell range should be offset (positive value - range is offset to the right, negative value - range is offset to the left, zero - range is not offset horizontally).

Parameters

Name Type Description
rowCount Int32

An integer that specifies the number of rows by which the cell range should be offset (positive value - range is offset down, negative value - range is offset up, zero - range is not offset vertically).

columnCount Int32

An integer that specifies the number of columns by which the cell range should be offset (positive value - range is offset to the right, negative value - range is offset to the left, zero - range is not offset horizontally).

Returns

Type Description
CellRange

A CellRange object that specifies the copy of the current range (by size) which is offset.

Returns

Type Description
CellRange

A CellRange object that specifies the copy of the current range (by size) which is offset.

Returns

Type Description
CellRange

A CellRange object that specifies the copy of the current range (by size) which is offset.

Remarks

Use the Offset method to access the cell range of the same size as the current range which is shifted by the specified number of rows and columns.

SpreadsheetControl_Range_Offset

See Also