Parent Property (Row)

In This Topic

Gets the parent collection of rows (Rows object) that contains this row.

Syntax

Visual Basic
C#

'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);

Visual Basic

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)

Reference

Row Class
Row Members
Rows Class

Product Support Forum | Print this page