Cell.RowIndex Property

Gets the index of the row that contains the current cell.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

int RowIndex { get; }

VB.NET

ReadOnly Property RowIndex As Integer

Property Value

Type	Description
Int32	A zero-based integer value that specifies the index of the row containing the current cell.

Remarks

Use the RowIndex and Cell.ColumnIndex properties to obtain indexes of the row and column at the intersection of which the current cell is located. To get row and column headings, use the Row.Heading and Column.Heading properties.

To get the string that specifies a cell reference, call the Range.GetReferenceA1 or Range.GetReferenceR1C1 method for this cell.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RowIndex property.

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#

xtraspreadsheet-custom-draw-examples-e5044/CS/CustomDrawExample/Form1.cs#L85

e.Handled = true;
bool is_selected = e.IsHovered || (e.RowIndex == spreadsheetControl1.ActiveCell.RowIndex);
Color backColor = is_selected ? Color.Yellow : Color.White;

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/CS/SpreadsheetCustomization/Form1.cs#L63

// Otherwise, obtain the bounds of the active cell and display the ComboBox control over it.
Rectangle cellRect = spreadsheetControl1.GetCellBounds(activeCell.RowIndex, activeCell.ColumnIndex);
if (cellRect.IsEmpty)

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/CS/SpreadsheetCustomization/Form1.cs#L117

    Cell activeCell = spreadsheetControl1.ActiveCell;
    return spreadsheetControl1.GetCellBounds(activeCell.RowIndex, activeCell.ColumnIndex);
}

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/CS/CustomCalculationServiceExample/Form1.cs#L35

{
    CellKey cellkey = new CellKey((e.Cell.Worksheet.Index + 1), e.Cell.ColumnIndex, e.Cell.RowIndex);
    if (calculationService.CircularReferencedCells.Contains(cellkey))

formula-engine-examples-of-use-t110344/CS/FormulaEngineTest/Form1.cs#L65

int columnIndex = this.contextCell.ColumnIndex;
int rowIndex = this.contextCell.RowIndex;
// Create the expression context.

VB.NET

xtraspreadsheet-custom-draw-examples-e5044/VB/CustomDrawExample/Form1.vb#L81

            e.Handled = True
            Dim is_selected As Boolean = e.IsHovered OrElse (e.RowIndex = spreadsheetControl1.ActiveCell.RowIndex)
'INSTANT VB NOTE: The variable backColor was renamed since Visual Basic does not handle local variables named the same as class members well:

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/VB/SpreadsheetCustomization/Form1.vb#L58

' Otherwise, obtain the bounds of the active cell and display the ComboBox control over it.
Dim cellRect As Rectangle = spreadsheetControl1.GetCellBounds(activeCell.RowIndex, activeCell.ColumnIndex)
If cellRect.IsEmpty Then

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/VB/SpreadsheetCustomization/Form1.vb#L118

    Dim activeCell As Cell = spreadsheetControl1.ActiveCell
    Return spreadsheetControl1.GetCellBounds(activeCell.RowIndex, activeCell.ColumnIndex)
End Function

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/VB/CustomCalculationServiceExample/Form1.vb#L33

Private Sub spreadsheetControl1_CustomDrawCell(ByVal sender As Object, ByVal e As DevExpress.XtraSpreadsheet.CustomDrawCellEventArgs)
    Dim cellkey As New CellKey((e.Cell.Worksheet.Index + 1), e.Cell.ColumnIndex, e.Cell.RowIndex)
    If calculationService.CircularReferencedCells.Contains(cellkey) Then

formula-engine-examples-of-use-t110344/VB/FormulaEngineTest/Form1.vb#L61

Dim columnIndex As Integer = Me.contextCell.ColumnIndex
Dim rowIndex As Integer = Me.contextCell.RowIndex
' Create the expression context.