SpreadsheetControl.GetCellFromPoint(PointF) Method

Gets a worksheet cell located at the specified point.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v23.2.dll

NuGet Package: DevExpress.Wpf.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 code sample below obtain a cell by the clicked point:

C#

using DevExpress.Xpf.Core;
using System.Windows.Input;
using DevExpress.Spreadsheet;
using System.Drawing;

private void spreadsheet_PreviewMouseDown(object sender, MouseButtonEventArgs e)
{
    System.Windows.Point p = e.GetPosition(spreadsheet);
    Cell cell = spreadsheet.GetCellFromPoint(new System.Drawing.PointF((float)p.X, (float)p.Y));
    if(cell != null)
    {
      //your code here
    }
} 

VB.NET

Imports DevExpress.Xpf.Core
Imports System.Windows.Input
Imports DevExpress.Spreadsheet
Imports System.Drawing

Private Sub spreadsheet_PreviewMouseDown(ByVal sender As Object, ByVal e As MouseButtonEventArgs)
  Dim p As System.Windows.Point = e.GetPosition(spreadsheet)
  Dim cell As Cell = spreadsheet.GetCellFromPoint(New System.Drawing.PointF(CSng(p.X), CSng(p.Y)))
  If cell IsNot Nothing Then
    'your code here
  End If
End Sub