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






Specifies the horizontal screen coordinate of the column to find.
Specifies the vertical screen coordinate of the row to find.
Returns the fractional zero based row.
Returns the fractional zero based column.
Specifies which pane to use and whether to include row and column headers and outlines in the calculations.
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, _
   ByVal flags As RangeLocationFlags _
) 
'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
Dim flags As RangeLocationFlags
 
instance.LocationToRange(x, y, row, column, flags)
public void LocationToRange( 
   System.double x,
   System.double y,
   out System.double row,
   out System.double column,
   RangeLocationFlags flags
)
public procedure LocationToRange( 
    x: System.Double;
    y: System.Double;
   Out  row: System.Double;
   Out  column: System.Double;
    flags: RangeLocationFlags
); 
public function LocationToRange( 
   x : System.double,
   y : System.double,
   row : System.double,
   column : System.double,
   flags : RangeLocationFlags
);
public: void LocationToRange( 
   System.double x,
   System.double y,
   [PARAMFLAG::Out] System.double row,
   [PARAMFLAG::Out] System.double column,
   RangeLocationFlags flags
) 
public:
void LocationToRange( 
   System.double x,
   System.double y,
   [Out] System.double row,
   [Out] System.double column,
   RangeLocationFlags flags
) 

Parameters

x
Specifies the horizontal screen coordinate of the column to find.
y
Specifies the vertical screen coordinate of the row to find.
row
Returns the fractional zero based row.
column
Returns the fractional zero based column.
flags
Specifies which pane to use and whether to include row and column headers and outlines in the calculations.
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) Method

Send Feedback