SetColumnResizable(Int32,SheetArea,Boolean) Method

Sets whether users can resize individual columns in the specified sheet area.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetColumnResizable( _
   ByVal column As Integer, _
   ByVal sheetArea As SheetArea, _
   ByVal value As Boolean _
)

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

public void SetColumnResizable( 
   int column,
   SheetArea sheetArea,
   bool value
)

Parameters

column: The column index.
sheetArea: The sheet area.
value: Set to true to allow users to resize the column.

Example

This example uses the SetColumnResizable method.

C#
VB.NET

gcSpreadSheet1.Sheets[0].SetColumnResizable(3, false);
gcSpreadSheet1.Sheets[0].SetRowResizable(3, false);
//gcSpreadSheet1.Sheets[0].SetColumnResizable(1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, false);
//gcSpreadSheet1.Sheets[0].SetRowResizable(1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, false);

GcSpreadSheet1.Sheets(0).SetColumnResizable(3, False)
GcSpreadSheet1.Sheets(0).SetRowResizable(3, False)
'GcSpreadSheet1.Sheets(0).SetColumnResizable(1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, False)
'GcSpreadSheet1.Sheets(0).SetRowResizable(1, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, False)

Reference

Worksheet Class
Worksheet Members
Overload List