GetColumnResizable(Int32,SheetArea) Method

Gets a value that indicates whether the user can resize a specified column in the specified sheet area.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetColumnResizable( _
   ByVal column As Integer, _
   ByVal sheetArea As SheetArea _
) As Boolean

'Usage
 
Dim instance As Worksheet
Dim column As Integer
Dim sheetArea As SheetArea
Dim value As Boolean
 
value = instance.GetColumnResizable(column, sheetArea)

public bool GetColumnResizable( 
   int column,
   SheetArea sheetArea
)

Parameters

column: The column index.
sheetArea: The sheet area.

Return Value

Returns true if the user can resize the specified column; otherwise, false.

Example

This example uses the GetColumnResizable method.

C#
VB.NET

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

Reference

Worksheet Class
Worksheet Members
Overload List