Spread Windows Forms 10.0 Product Documentation
ExpandRow Method (SheetView)
Example 


Index of parent row to expand or collapse
Whether to expand and show the child sheet (or collapse and hide it)
Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.
Syntax
'Declaration
 
Public Sub ExpandRow( _
   ByVal row As Integer, _
   ByVal expand As Boolean _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim expand As Boolean
 
instance.ExpandRow(row, expand)
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.
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());
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Working with Hierarchical Data Display

 

 


Copyright © GrapeCity, inc. All rights reserved.