Spread ASP.NET 18
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / Parent Property
Example


In This Topic
    Parent Property (Row)
    In This Topic
    Gets the parent collection of rows (Rows object) that contains this row.
    Syntax
    'Declaration
     
    
    Public ReadOnly Property Parent As Rows
    'Usage
     
    
    Dim instance As Row
    Dim value As Rows
     
    value = instance.Parent
    public Rows Parent {get;}

    Property Value

    Parent Rows object containing this row
    Example
    This example creates a Row object and adjusts the alignment of the text in the row by using an Inset object. The width of the column is changed so that the alignment changes can be easily seen. The Parent of the Row object is then returned to a text box.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Row myrow;
    FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(20,50,80,20);
    myrow=FpSpread1.ActiveSheetView.Rows[1];
    myrow.Margin=inset;
    FpSpread1.ActiveSheetView.Columns[1].Width=140;
    for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
    {
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
    }
    TextBox1.Text=Convert.ToString(myrow.Parent);
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim myrow As FarPoint.Web.Spread.Row
    Dim inset As New FarPoint.Web.Spread.Inset(20,50,80,20)
    Dim row,i As Integer
    row=1
    myrow=FpSpread1.ActiveSheetView.Rows(row)
    myrow.Margin=inset
    FpSpread1.ActiveSheetView.Columns(1).Width=140
    Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
    Next i
    TextBox1.Text=Convert.ToString(myrow.Parent)
    See Also