Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ExpandRow Method
Index of parent row to expand or collapse
Whether to expand and show the child sheet (or collapse and hide it)
Example


In This Topic
    ExpandRow Method (SheetView)
    In This Topic
    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
    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())
    See Also