Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetSpanModel Class / Find Method
Row index of the cell
Column index of the cell
Example


In This Topic
    Find Method (DefaultSheetSpanModel)
    In This Topic
    Finds the cell span in the collection that includes the cell at specified row and column.
    Syntax
    'Declaration
     
    Public Overrides Function Find( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As CellRange
    'Usage
     
    Dim instance As DefaultSheetSpanModel
    Dim row As Integer
    Dim column As Integer
    Dim value As CellRange
     
    value = instance.Find(row, column)
    public override CellRange Find( 
       int row,
       int column
    )

    Parameters

    row
    Row index of the cell
    column
    Column index of the 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.
    FarPoint.Win.Spread.Model.DefaultSheetSpanModel defspanModel = new FarPoint.Win.Spread.Model.DefaultSheetSpanModel();
    FarPoint.Win.Spread.Model.CellRange cr;
    fpSpread1.ActiveSheet.Models.Span = defspanModel;
    defspanModel.Add(0, 0, 3, 3);
    cr = defspanModel.Find(1, 1);
    listBox1.Items.Add(cr.ToString());
    Dim defspanModel As New FarPoint.Win.Spread.Model.DefaultSheetSpanModel()
    Dim cr As FarPoint.Win.Spread.Model.CellRange
    FpSpread1.ActiveSheet.Models.Span = defspanModel
    defspanModel.Add(0, 0, 3, 3)
    cr = defspanModel.Find(1, 1)
    ListBox1.Items.Add(cr.ToString())
    See Also