Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / Index2 Property
Example


In This Topic
    Index2 Property (Column)
    In This Topic
    Gets the ending index for this range of columns.
    Syntax
    'Declaration
 

    Public ReadOnly Property Index2 As Integer
    'Usage
 

    Dim instance As Column
Dim value As Integer
 
value = instance.Index2
    public int Index2 {get;}

    Property Value

    Integer index (zero-based) of the column at the end of the range
    Remarks
    Use the Index property to specify the starting index for the range.
    Example
    This example creates a multiple Column object and adjusts the alignment of the text in the column. The height of the rows are changed so that the alignment changes can be seen easily. The ending index (Index2) of the Column object is returned to a text box.
    FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1,3];
mycol.HorizontalAlign=HorizontalAlign.Right;
mycol.VerticalAlign=VerticalAlign.Top;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Rows[i].Height=80;
}

TextBox1.Text=Convert.ToString(mycol.Index2);
    FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim i As Integer
mycol=FpSpread1.ActiveSheetView.Columns(1,3)
mycol.HorizontalAlign=HorizontalAlign.Right
mycol.VerticalAlign=VerticalAlign.Top
For i=0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Next i
TextBox1.Text=Convert.ToString(mycol.Index2)
    See Also

    Reference

    Column Class
    Column Members
    Index Property