GrapeCity.Xaml.SpreadSheet.Data
GetRowResizable(Int32,SheetArea) Method
Example 


The row index.
The sheet area.
Gets a value that indicates whether users can resize the specified row in the specified sheet area.
Syntax
'Declaration
 
Public Overloads Function GetRowResizable( _
   ByVal row As Integer, _
   ByVal sheetArea As SheetArea _
) As Boolean
'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim sheetArea As SheetArea
Dim value As Boolean
 
value = instance.GetRowResizable(row, sheetArea)
public bool GetRowResizable( 
   int row,
   SheetArea sheetArea
)

Parameters

row
The row index.
sheetArea
The sheet area.

Return Value

Returns true if the users can resize the specified row; otherwise, false.
Example
This example uses the GetRowResizable method.
private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            gcSpreadSheet1.Sheets[0].ColumnCount = 7;
            gcSpreadSheet1.Sheets[0].RowCount = 10;
            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].SetColumnResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, true);
            gcSpreadSheet1.Sheets[0].SetRowResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, true);
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetColumnResizable(0).ToString());
            //ListBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetColumnResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader).ToString());
            //ListBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowResizable(0).ToString());
            listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetRowResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader).ToString());          
        }
Private Sub MainPage_Loaded(sender As Object, e As RoutedEventArgs) Handles Me.Loaded
        gcSpreadSheet1.Sheets(0).ColumnCount = 7
        gcSpreadSheet1.Sheets(0).RowCount = 10
        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).SetColumnResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader, True)
        gcSpreadSheet1.Sheets(0).SetRowResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader, True)
    End Sub

    Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).GetColumnResizable(0).ToString())
        'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetColumnResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.ColumnHeader).ToString())
        'ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetRowResizable(0).ToString())
        ListBox1.Items.Add(gcSpreadSheet1.Sheets(0).GetRowResizable(0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.RowHeader).ToString())
    End Sub
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

Worksheet Class
Worksheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options