Gets the collection of columns (Columns object) containing this column.
Syntax
| Visual Basic (Declaration) | |
|---|
Public ReadOnly Property Parent As Columns |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As Columns
value = instance.Parent |
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.
| C# | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Columnmycol;
FarPoint.Web.Spread.Insetinset=NewFarPoint.Web.Spread.Inset(20,50,80,20);
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Margin=inset;
For(inti=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Rows[i].Height=80;
}
TextBox1.Text=Convert.ToString(mycol.Parent); |
| Visual Basic | Copy Code |
|---|
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
DimmycolAsFarPoint.Web.Spread.Column
DiminsetAsNewFarPoint.Web.Spread.Inset(20,50,80,20)
DimiAsInteger
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Margin=inset
Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Nexti
TextBox1.Text=Convert.ToString(mycol.Parent) |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
