Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / RangeGroup Class / Expand Method / Expand(Int32,Boolean) Method
The level of the outline to expand or collapse.
Whether to expand the groups.
Example


In This Topic
    Expand(Int32,Boolean) Method
    In This Topic
    Expands all outlines (range groups), by the specified level.
    Syntax
    'Declaration
     
    Public Overloads Sub Expand( _
       ByVal level As Integer, _
       ByVal expand As Boolean _
    ) 
    'Usage
     
    Dim instance As RangeGroup
    Dim level As Integer
    Dim expand As Boolean
     
    instance.Expand(level, expand)
    public void Expand( 
       int level,
       bool expand
    )

    Parameters

    level
    The level of the outline to expand or collapse.
    expand
    Whether to expand the groups.
    Example
    This example uses the Expand method.
    gcSpreadSheet1.Sheets[0].ColumnCount = 7;
    gcSpreadSheet1.Sheets[0].RowCount = 34;
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Western";
    gcSpreadSheet1.Sheets[0].Cells[0, 1].Text = "Western";
    gcSpreadSheet1.Sheets[0].Cells[0, 2].Text = "Western";
    gcSpreadSheet1.Sheets[0].Cells[1, 0].Text = "A";
    gcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "B";
    gcSpreadSheet1.Sheets[0].Cells[1, 2].Text = "C";
    gcSpreadSheet1.Sheets[0].Cells[2, 0].Text = "A";
    gcSpreadSheet1.Sheets[0].Cells[2, 1].Text = "B";
    gcSpreadSheet1.Sheets[0].Cells[2, 2].Text = "C";
    gcSpreadSheet1.Sheets[0].RowRangeGroup.Group(0, 2);
    //The following code removes the row range group
    //gcSpreadSheet1.Sheets[0].RowRangeGroup.Ungroup(0, 2);
    gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Group(0, 1);
    //The following code removes the column range group
    //gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Ungroup(0, 1);      
    gcSpreadSheet1.Invalidate();
    
    private void button1_Click(object sender, RoutedEventArgs e)
            {
    gcSpreadSheet1.Sheets[0].RowRangeGroup.Expand(0, false);
    gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Expand(0, false);
    gcSpreadSheet1.Invalidate();
          }
    GcSpreadSheet1.Sheets(0).ColumnCount = 7
    GcSpreadSheet1.Sheets(0).RowCount = 34
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "Western"
    GcSpreadSheet1.Sheets(0).Cells(0, 1).Text = "Western"
    GcSpreadSheet1.Sheets(0).Cells(0, 2).Text = "Western"
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Text = "A"
    GcSpreadSheet1.Sheets(0).Cells(1, 1).Text = "B"
    GcSpreadSheet1.Sheets(0).Cells(1, 2).Text = "C"
    GcSpreadSheet1.Sheets(0).Cells(2, 0).Text = "A"
    GcSpreadSheet1.Sheets(0).Cells(2, 1).Text = "B"
    GcSpreadSheet1.Sheets(0).Cells(2, 2).Text = "C"
    GcSpreadSheet1.Sheets(0).RowRangeGroup.Group(0, 2)
    'The following code removes the row range group
    'GcSpreadSheet1.Sheets(0).RowRangeGroup.Ungroup(0, 2)
    GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Group(0, 1)
    'The following code removes the column range group
    'GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Ungroup(0, 1)      
    GcSpreadSheet1.Invalidate()
    
     Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
    GcSpreadSheet1.Sheets(0).RowRangeGroup.Expand(0, False)
    GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Expand(0, False)
    GcSpreadSheet1.Invalidate()
    End Sub
    See Also