Finds the cell span with the specified cell in the collection.
            
            
            
Syntax
            Parameters
- row
 
- Row index of the cell.
 - column
 
- Column index of cell.
 
            
            Return Value
CellRange object containing the range of cells spanned
 
            
						
            
            
            
            
Example
This example finds the cell span in the collection that includes the specified cell.
             
| C# |  Copy Code | 
|---|
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 |  Copy Code | 
|---|
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 | 
 
 
            
            
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
 
            
            
See Also