SpreadsheetControl.GetCellFromPoint(PointF) Method

Gets a worksheet cell located at the specified point.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

public Cell GetCellFromPoint(
    PointF clientPoint
)

VB.NET

Public Function GetCellFromPoint(
    clientPoint As PointF
) As Cell

Parameters

Name	Type	Description
clientPoint	PointF	A PointF structure specifying the location for which the position is retrieved. The point coordinates are measured in documents units.

Returns

Type	Description
Cell	A Cell object.

Remarks

The following code snippet displays cell coordinates of the cell located under the mouse cursor.

C#

spreadsheetControl1.MouseMove+=spreadsheetControl1_MouseMove;
// ...
private void spreadsheetControl1_MouseMove(object sender, MouseEventArgs e)
{
    Cell cell = spreadsheetControl1.GetCellFromPoint(new PointF(e.X, e.Y));
    this.Text = cell == null ? "No Cell" : cell.GetReferenceA1() ;
}

VB.NET

AddHandler spreadsheetControl1.MouseMove
' ...
    Dim cell As Cell = spreadsheetControl1.GetCellFromPoint(New PointF(e.X, e.Y))
    Me.Text = If(cell Is Nothing, "No Cell", cell.GetReferenceA1())

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetCellFromPoint(PointF) 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-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/CS/SuppliersExample/Form1.cs#L38

private void spreadsheetControl1_MouseClick(object sender, MouseEventArgs e) {
    Cell cell = spreadsheetControl1.GetCellFromPoint(e.Location);
    if (cell == null)

How-to-show-custom-tooltips-in-SpreadsheetControl/CS/SpreadsheetTooltip/Form1.cs#L29

    return;
Cell cell = spreadsheetControl1.GetCellFromPoint(new PointF(e.ControlMousePosition.X, e.ControlMousePosition.Y));
if (cell == null) return;

VB.NET

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-t472324/VB/SuppliersExample/Form1.vb#L38

Private Sub spreadsheetControl1_MouseClick(ByVal sender As Object, ByVal e As MouseEventArgs) Handles spreadsheetControl1.MouseClick
    Dim cell As Cell = spreadsheetControl1.GetCellFromPoint(e.Location)
    If cell Is Nothing Then

How-to-show-custom-tooltips-in-SpreadsheetControl/VB/SpreadsheetTooltip/Form1.vb#L28

End If
Dim cell As Cell = spreadsheetControl1.GetCellFromPoint(New PointF(e.ControlMousePosition.X, e.ControlMousePosition.Y))
If cell Is Nothing Then