Finds the cell span in the collection that includes the cell at the specified row and column.
            
            
            
Syntax
            Parameters
- row
 
- Row index of cell
 - column
 
- Column index of cell
 
            
            Return Value
CellRange object containing the cell range with the specified cell
 
            
						
            
            
            
            
Example
This example finds the cell span in the collection that includes the specified cell.
             
| C# |  Copy Code | 
|---|
private void menuItem1_Click(object sender, System.EventArgs e)
{
    FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
    spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
    spanModel.Add(0, 0, 2, 2);
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
    FarPoint.Win.Spread.Model.BaseSheetSpanModel spanModel;
    FarPoint.Win.Spread.Model.CellRange cr;
    spanModel = (FarPoint.Win.Spread.Model.BaseSheetSpanModel)fpSpread1.ActiveSheet.Models.Span;
    cr = spanModel.Find(1, 1);
    listBox1.Items.AddRange(new Object[] {cr.Column.ToString(), cr.Row.ToString(), cr.ColumnCount.ToString(), cr.RowCount.ToString()});
} | 
 
| Visual Basic |  Copy Code | 
|---|
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
    Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
    spanModel = FpSpread1.ActiveSheet.Models.Span
    spanModel.Add(0, 0, 2, 2)
End Sub
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
    Dim spanModel As FarPoint.Win.Spread.Model.BaseSheetSpanModel
    Dim cr As FarPoint.Win.Spread.Model.CellRange
    spanModel = FpSpread1.ActiveSheet.Models.Span
    cr = spanModel.Find(1, 1)
    ListBox1.Items.AddRange(New Object() {cr.Column.ToString(), cr.Row.ToString(), cr.ColumnCount.ToString(), cr.RowCount.ToString()})
End Sub | 
 
 
            
            
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