GrapeCity.Xaml.SpreadSheet.Data
Expand(Int32,Boolean) Method
Example 


The level of the outline to expand or collapse.
Whether to expand the groups.
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.
private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            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);     
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            gcSpreadSheet1.Sheets[0].RowRangeGroup.Expand(0, false);
            gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Expand(0, false);
        }
Private Sub MainPage_Loaded(sender As Object, e As RoutedEventArgs) Handles Me.Loaded
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)     
End Sub

Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
GcSpreadSheet1.Sheets(0).RowRangeGroup.Expand(0, False)
GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Expand(0, False)
End Sub
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

RangeGroup Class
RangeGroup Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options