Spread Windows Forms 7.0 Product Documentation
ExpandRow Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : ExpandRow Method


row
Index of parent row to expand or collapse
expand
Whether to expand and show the child sheet (or collapse and hide it)

Glossary Item Box

Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.

Syntax

Visual Basic (Declaration) 
Public Sub ExpandRow( _
   ByVal row As Integer, _
   ByVal expand As Boolean _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim row As Integer
Dim expand As Boolean
 
instance.ExpandRow(row, expand)
C# 
public void ExpandRow( 
   int row,
   bool expand
)

Parameters

row
Index of parent row to expand or collapse
expand
Whether to expand and show the child sheet (or collapse and hide it)

Return Value

If expand is set to true, the hierarchy is expanded and the child sheet(s) is (are) displayed. If it is set to false, the hierarchy is collapsed and the child sheet(s) is (are) hidden.

Exceptions

ExceptionDescription
System.ArgumentOutOfRangeException Specified parent row index is out of range; must be between 0 and the total number of rows

Remarks

The Expand event does not fire when using the sheet view ExpandRow method.

Example

This example expands the second child view of the spreadsheet.
C#Copy Code
System.Data.DataSet ds = new System.Data.DataSet();
DataTable name; 
DataTable city; 
name = ds.Tables.Add("Customers"); 
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),
new DataColumn("ID", typeof(Int32))}); 
name.Rows.Add(new object[] {"Fielding", "William", 0}); 
name.Rows.Add(new object[] {"Williams", "Arthur", 1}); 
name.Rows.Add(new object[] {"Zuchini", "Theodore", 2}); 
city = ds.Tables.Add("City/State"); 
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new
DataColumn("State", typeof(string))}); 
city.Rows.Add(new object[] {"Atlanta", 0, "Georgia"}); 
city.Rows.Add(new object[] {"Boston", 1, "Mass."}); 
city.Rows.Add(new object[] {"Tampa", 2, "Fla."}); 
ds.Relations.Add("City/State", name.Columns["ID"], city.Columns["Owner"]); 
fpSpread1.ActiveSheet.DataSource = ds;  
fpSpread1.ActiveSheet.DataMember = "Customers";
fpSpread1.ActiveSheet.SetColumnWidth(2, 150);  
bool b;
fpSpread1.ActiveSheet.ExpandRow(1, true);
b = fpSpread1.ActiveSheet.IsRowExpanded(1);
listBox1.Items.Add(b.ToString());
Visual BasicCopy Code
Dim ds As New System.Data.DataSet()
Dim name As DataTable
Dim city As DataTable
name = ds.Tables.Add("Customers")
name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", Type.GetType("System.String")), New DataColumn("FirstName",
Type.GetType("System.String")), New DataColumn("ID", Type.GetType("System.Int32"))})
name.Rows.Add(New Object() {"Fielding", "William", 0})
name.Rows.Add(New Object() {"Williams", "Arthur", 1})
name.Rows.Add(New Object() {"Zuchini", "Theodore", 2})
city = ds.Tables.Add("City/State")
city.Columns.AddRange(New DataColumn() {New DataColumn("City", Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")),
New DataColumn("State", Type.GetType("System.String"))})
city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"})
city.Rows.Add(New Object() {"Boston", 1, "Mass."})
city.Rows.Add(New Object() {"Tampa", 2, "Fla."})
ds.Relations.Add("City/State", name.Columns("ID"), city.Columns("Owner"))
Dim b As Boolean
FpSpread1.ActiveSheet.DataSource = ds
FpSpread1.ActiveSheet.DataMember = "Customers"
FpSpread1.ActiveSheet.SetColumnWidth(2, 150)
FpSpread1.ActiveSheet.ExpandRow(1, True)
b = FpSpread1.ActiveSheet.IsRowExpanded(1)
ListBox1.Items.Add(b.ToString())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.