Find Method (ISheetSpanModel)

Finds the cell span with the specified cell in the collection.

Syntax

Visual Basic
C#

'Declaration
 
Function Find( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As CellRange

'Usage
 
Dim instance As ISheetSpanModel
Dim row As Integer
Dim column As Integer
Dim value As CellRange
 
value = instance.Find(row, column)

CellRange Find( 
   int row,
   int column
)

Parameters

row: Row index of the cell.
column: Column index of cell.

Return Value

CellRange object containing the cell range

Example

FarPoint.Web.Spread.Model.ISheetSpanModel iss;
iss = (FarPoint.Web.Spread.Model.ISheetSpanModel)FpSpread1.ActiveSheetView.SpanModel;
FarPoint.Web.Spread.Model.CellRange cr;
cr = iss.Find(0, 0);
string msg = "The first column in the span is " + cr.Column.ToString();
Response.Write("<script language='javascript'>alert('" + msg + "')</script>");

Visual Basic

Dim iss As FarPoint.Web.Spread.Model.ISheetSpanModel
iss = FpSpread1.ActiveSheetView.SpanModel
Dim cr As FarPoint.Web.Spread.Model.CellRange
cr = iss.Find(0, 0)
Dim msg As String = "The first column in the span is " + cr.Column.ToString()
Response.Write("<script language='javascript'>alert('" & msg & "')</script>")

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ISheetSpanModel Interface
ISheetSpanModel Members