Cell.ColumnIndex Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

int ColumnIndex { get; }

VB.NET

ReadOnly Property ColumnIndex As Integer

Property Value

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

Remarks

Use the ColumnIndex and Cell.RowIndex properties to obtain indexes of the column and row at the intersection of which the current cell is located. To get column and row headings, use the Column.Heading and Row.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 ColumnIndex 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#L53

e.Handled = true;
bool is_selected = e.IsHovered || (e.ColumnIndex == spreadsheetControl1.ActiveCell.ColumnIndex);
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#L64

// Get coordinates of the context cell.
int columnIndex = this.contextCell.ColumnIndex;
int rowIndex = this.contextCell.RowIndex;

VB.NET

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

            e.Handled = True
            Dim is_selected As Boolean = e.IsHovered OrElse (e.ColumnIndex = spreadsheetControl1.ActiveCell.ColumnIndex)
'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#L60

' Get coordinates of the context cell.
Dim columnIndex As Integer = Me.contextCell.ColumnIndex
Dim rowIndex As Integer = Me.contextCell.RowIndex