Spread for ASP.NET 11 Product Documentation
Parent Property (Column)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Column Class : Parent Property
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

Reference

Column Class
Column Members
Columns Class