Range.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.1.Core.dll

Declaration

C#

Range Offset(
    int rowCount,
    int columnCount
)

VB.NET

Function Offset(
    rowCount As Integer,
    columnCount As Integer
) As Range

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

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Offset(Int32, 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#

wpf-spreadsheet-pivot-table-api-t314425/CS/SpreadsheetWPFPivotTableExamples/MainWindow.xaml.cs#L52

Range usedRange = firstSheet.GetUsedRange();
firstSheet.SelectedCell = usedRange[usedRange.RowCount * usedRange.ColumnCount - 1].Offset(1, 1);

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/Form1.cs#L102

Range usedRange = active.GetUsedRange();
active.SelectedCell = usedRange[usedRange.RowCount * usedRange.ColumnCount - 1].Offset(1, 1);

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L199

void MoveUpLastRecord(Range itemRange) {
    Range range = itemRange.Offset(-1, 0);
    range.CopyFrom(itemRange, PasteSpecial.All, true);

wpf-spreadsheet-chart-api-t113198/CS/SpreadsheetWPFChartAPISamples/MainWindow.xaml.cs#L60

Range usedRange = firstSheet.GetUsedRange();
firstSheet.SelectedCell = usedRange[usedRange.RowCount * usedRange.ColumnCount - 1].Offset(1, 1);

winforms-spreadsheet-chart-api-e5222/CS/SpreadsheetChartAPISamples/Form1.cs#L119

    Range usedRange =active.GetUsedRange();
    active.SelectedCell = usedRange[usedRange.RowCount * usedRange.ColumnCount - 1].Offset(1, 1);
}

VB.NET

wpf-spreadsheet-pivot-table-api-t314425/VB/SpreadsheetWPFPivotTableExamples/MainWindow.xaml.vb#L51

Dim usedRange As Range = firstSheet.GetUsedRange()
firstSheet.SelectedCell = usedRange(usedRange.RowCount * usedRange.ColumnCount - 1).Offset(1, 1)

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/Form1.vb#L98

Dim usedRange As Range = active.GetUsedRange()
active.SelectedCell = usedRange(usedRange.RowCount * usedRange.ColumnCount - 1).Offset(1, 1)

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L204

Private Sub MoveUpLastRecord(ByVal itemRange As Range)
    Dim range As Range = itemRange.Offset(-1, 0)
    range.CopyFrom(itemRange, PasteSpecial.All, True)

wpf-spreadsheet-chart-api-t113198/VB/SpreadsheetWPFChartAPISamples/MainWindow.xaml.vb#L61

Dim usedRange As Range = firstSheet.GetUsedRange()
firstSheet.SelectedCell = usedRange(usedRange.RowCount * usedRange.ColumnCount - 1).Offset(1, 1)

winforms-spreadsheet-chart-api-e5222/VB/SpreadsheetChartAPISamples/Form1.vb#L115

    Dim usedRange As Range = active.GetUsedRange()
    active.SelectedCell = usedRange(usedRange.RowCount * usedRange.ColumnCount - 1).Offset(1, 1)
End If