Find Method (ISheetSpanModel)

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 range of cells spanned

This example finds the cell span in the collection that includes the specified cell.

C#

FarPoint.Win.Spread.Model.ISheetSpanModel sp;
FarPoint.Win.Spread.Model.CellRange cr;
DialogResult dlg;
sp = (FarPoint.Win.Spread.Model.ISheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
sp.Add(0, 0, 2, 2);
sp.Add(0, 3, 2, 2);
dlg = MessageBox.Show("Do you want to find the specified span??", "Find", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
     cr = sp.Find(1, 3);
     label1.Text = "The column index of the cell is " + cr.Column + " and the row index is " + cr.Row;
}

Visual Basic

Dim sp As FarPoint.Win.Spread.Model.ISheetSpanModel
Dim cr As FarPoint.Win.Spread.Model.CellRange
Dim dlg As DialogResult
sp = FpSpread1.ActiveSheet.Models.Span
sp.Add(0, 0, 2, 2)
sp.Add(0, 3, 2, 2)
dlg = MessageBox.Show("Do you want to find the specified span??", "Find", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
     cr = sp.Find(1, 3)
     Label1.Text = "The column index of the cell is " & cr.Column  & " and the row index is " & cr.Row
End If

Reference

ISheetSpanModel Interface
ISheetSpanModel Members