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


In This Topic
    Parent Property (Column)
    In This Topic
    Gets the collection of columns (Columns object) that contains this column.
    Syntax
    'Declaration
     
    
    Public ReadOnly Property Parent As Columns
    'Usage
     
    
    Dim instance As Column
    Dim value As Columns
     
    value = instance.Parent
    public Columns Parent {get;}

    Property Value

    Parent Columns object containing this column
    Example
    This example creates a Column object and adjusts the alignment of the text in the column via an Inset object. The height of the rows are changed so that the alignment changes can be easily seen. The Parent of the Column object is then returned to a text box.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Column mycol;
    FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(20,50,80,20);
    mycol=FpSpread1.ActiveSheetView.Columns[1];
    mycol.Margin=inset;
    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.Parent);
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim mycol As FarPoint.Web.Spread.Column
    Dim inset As New FarPoint.Web.Spread.Inset(20,50,80,20)
    Dim i As Integer
    mycol=FpSpread1.ActiveSheetView.Columns(1)
    mycol.Margin=inset
    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.Parent)
    See Also