Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / Index2 Property
Example


In This Topic
    Index2 Property (Row)
    In This Topic
    Gets the ending index for this range of rows.
    Syntax
    'Declaration
     
    Public ReadOnly Property Index2 As Integer
    'Usage
     
    Dim instance As Row
    Dim value As Integer
     
    value = instance.Index2
    public int Index2 {get;}

    Property Value

    Integer index (zero-based) of the row at the end of the range
    Remarks
    Use the Index property to specify the starting index for the range.
    Example
    This example creates a Row object with multiple columns and rows, and adjusts the alignment of the text in some of the rows. The width of the column is changed so that the alignment changes can be easily seen. The Index2 of the Row object is returned to a text box.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Rowmyrow;
    myrow=FpSpread1.ActiveSheetView.Rows[1,3];
    myrow.HorizontalAlign=HorizontalAlign.Right;
    myrow.VerticalAlign=VerticalAlign.Top;
    FpSpread1.ActiveSheetView.Columns[1].Width=140;
    for(inti=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
    {
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
    }
    TextBox1.Text=Convert.ToString(myrow.Index2);
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    DimmyrowAsFarPoint.Web.Spread.Row
    Dimrow,row1,iAsInteger
    row=1
    row1=3
    myrow=FpSpread1.ActiveSheetView.Rows(row,row1)
    myrow.HorizontalAlign=HorizontalAlign.Right
    myrow.VerticalAlign=VerticalAlign.Top
    FpSpread1.ActiveSheetView.Columns(i).Width=140
    Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
    Nexti
    TextBox1.Text=Convert.ToString(myrow.Index2)
    See Also