SpreadsheetControl.GetCellBounds(Int32, Int32) Method

Obtains the coordinates and size of a cell specified by the row and column indices.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

public Rectangle GetCellBounds(
    int rowIndex,
    int columnIndex
)

VB.NET

Public Function GetCellBounds(
    rowIndex As Integer,
    columnIndex As Integer
) As Rectangle

Parameters

Name	Type	Description
rowIndex	Int32	An integer that is the zero-based index of the row that contains the required cell.
columnIndex	Int32	An integer that is the zero-based index of the column that contains the required cell.

Returns

Type	Description
Rectangle	A Rectangle object that is the rectangle with the specified location and size in pixels.

Remarks

The GetCellBounds method returns the Rectangle object that specifies a cell’s x- and y-coordinates relative to the SpreadsheetControl‘s top-left corner, and the cell’s width and height.

The GetCellBounds method takes into account zoom settings specified for an active worksheet (SpreadsheetControl.ActiveViewZoom).

If the cell you specify is out of the currently visible range (defined by the SpreadsheetControl.VisibleRange property), the GetCellBounds method returns an empty rectangle.

If the specified cell is a part of the merged cell, the boundaries of returned rectangle will equal the bounds of the entire merged cell.

Related GitHub Examples

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

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);
}

VB.NET

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