SpreadsheetGear
LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method
See Also  Send Feedback
SpreadsheetGear.Windows.Forms Namespace > WorkbookView Class > LocationToRange Method : LocationToRange(Double,Double,Double,Double,RangeLocationFlags) Method

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 in the calculations.
Returns the fractional zero based row and column indexes representing the cell at the specified location.

Syntax

Visual Basic (Declaration) 
Public Overloads Sub LocationToRange( _
   ByVal x As Double, _
   ByVal y As Double, _
   ByRef row As Double, _
   ByRef column As Double, _
   ByVal flags As RangeLocationFlags _
)
C# 
public void LocationToRange( 
   double x,
   double y,
   out double row,
   out 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 in the calculations.

Requirements

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.