SpreadsheetGear 2012
LocationToRange(Double,Double,Double,Double) Method






The horizontal screen coordinate of the column to find.
The vertical screen coordinate of the row to find.
The fractional zero based row.
The fractional zero based column.
Returns the fractional zero based row and column indexes representing the cell at the specified location.
Syntax
'Declaration
 
Public Overloads Sub LocationToRange( _
   ByVal x As System.Double, _
   ByVal y As System.Double, _
   ByRef row As System.Double, _
   ByRef column As System.Double _
) 
'Usage
 
Dim instance As WorkbookView
Dim x As System.Double
Dim y As System.Double
Dim row As System.Double
Dim column As System.Double
 
instance.LocationToRange(x, y, row, column)
public void LocationToRange( 
   System.double x,
   System.double y,
   out System.double row,
   out System.double column
)
public procedure LocationToRange( 
    x: System.Double;
    y: System.Double;
   Out  row: System.Double;
   Out  column: System.Double
); 
public function LocationToRange( 
   x : System.double,
   y : System.double,
   row : System.double,
   column : System.double
);
public: void LocationToRange( 
   System.double x,
   System.double y,
   [PARAMFLAG::Out] System.double row,
   [PARAMFLAG::Out] System.double column
) 
public:
void LocationToRange( 
   System.double x,
   System.double y,
   [Out] System.double row,
   [Out] System.double column
) 

Parameters

x
The horizontal screen coordinate of the column to find.
y
The vertical screen coordinate of the row to find.
row
The fractional zero based row.
column
The fractional zero based column.
Requirements

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

See Also

Reference

WorkbookView Class
WorkbookView Members
Overload List
LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method

Send Feedback