Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / CellRange Class / CellRange Constructor / CellRange Constructor(Int32,Int32,Int32,Int32)
Row index of first cell in the range
Column index of first cell in the range
Number of rows in the range
Number of columns in the range
Example


In This Topic
    CellRange Constructor(Int32,Int32,Int32,Int32)
    In This Topic
    Creates a range of cells.
    Syntax
    'Declaration
     
    
    Public Function New( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    )
    'Usage
     
    
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
     
    Dim instance As New CellRange(row, column, rowCount, columnCount)
    public CellRange( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    Row index of first cell in the range
    column
    Column index of first cell in the range
    rowCount
    Number of rows in the range
    columnCount
    Number of columns in the range
    Example
    This example uses a CellRange to create a span in the sheet. The values returned from several of the methods of the range are put in a list box.
    FarPoint.Web.Spread.Model.CellRange range=new FarPoint.Web.Spread.Model.CellRange(0,0,4,4);
    bool b;
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.RowCount=10;
    FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount);
    b=range.Contains(1,1);
    ListBox1.Items.Add(Convert.ToString(b));
    Dim range As New FarPoint.Web.Spread.Model.CellRange(0,0,4,4)
    Dim b As Boolean
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.RowCount=10
    FpSpread1.ActiveSheetView.AddSpanCell(range.Row,range.Column,range.RowCount,range.ColumnCount)
    b=range.Contains(1,1)
    ListBox1.Items.Add(b)
    See Also