wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-dot-getcellfrompoint-x28-system-dot-drawing-dot-pointf-x29.md
Gets a worksheet cell located at the specified point.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public Cell GetCellFromPoint(
PointF clientPoint
)
Public Function GetCellFromPoint(
clientPoint As PointF
) As Cell
| 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.
|
| Type | Description |
|---|---|
| Cell |
A Cell object.
|
The code sample below obtain a cell by the clicked point:
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
}
}
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
See Also