Public Overloads Function GetCellFromPixel( _
   ByVal rowViewportIndex As Integer, _
   ByVal columnViewportIndex As Integer, _
   ByVal x As Integer, _
   ByVal y As Integer _
) As CellRange

Visual Basic (Usage)	Copy Code
Dim instance As SpreadView Dim rowViewportIndex As Integer Dim columnViewportIndex As Integer Dim x As Integer Dim y As Integer Dim value As CellRange   value = instance.GetCellFromPixel(rowViewportIndex, columnViewportIndex, x, y)

public CellRange GetCellFromPixel( 
   int rowViewportIndex,
   int columnViewportIndex,
   int x,
   int y
)

Parameters

rowViewportIndex

Row index in the viewport

columnViewportIndex

Column index in the viewport

x

X-coordinate (in pixels) of the pointer location

y

Y-coordinate (in pixels) of the pointer location

Return Value

This method returns a CellRange object that consists of row and column coordinates and row and column counts. If a cell exists at the pixel location, then the method returns CellRange(row, column, 1, 1) where row, column are the row index and column index of the cell. If a cell does not exist at the pixel location then the method returns CellRange(-1,-1,-1,-1).

Use the x and y parameters to specify the location (pixel) on the display and use the rowviewportindex and columnviewportindex parameters to specify a particular viewport.

This method only returns cell information for pixel locations in the data area of the sheet, and not for headers or sheet corner or other parts of the Spread component. For cells in the column headers and row headers, use the GetColumnHeaderCellFromPixel and GetRowHeaderCellFromPixel methods.

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

User-Task Documentation