SpreadsheetControl.GetCellFromPoint(PointF) Method

Gets a worksheet cell located at the specified point.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

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 snippet (auto-collected from DevExpress Examples) contains a reference 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#

winforms-spreadsheet-bind-to-ms-sql-server-database/CS/SuppliersExample/Form1.cs#L38

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

VB.NET

winforms-spreadsheet-bind-to-ms-sql-server-database/VB/SuppliersExample/Form1.vb#L41

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