Resizable Property (Column)

In This Topic

Gets or sets whether this column can be resized.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Resizable As Boolean

'Usage
 
Dim instance As Column
Dim value As Boolean
 
instance.Resizable = value
 
value = instance.Resizable

public bool Resizable {get; set;}

Property Value

true if the user can resize this column; false otherwise

Example

This example creates a spreadsheet with 10 columns and 20 rows. A Column object is created and assigned to the second column. Text and margins are set for the cells in the column and the user is not able to resize the column.

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(20,50,80,20);
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Margin=inset;
mycol.Resizable=false;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
FpSpread1.ActiveSheetView.Rows[i].Height=80;
}

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim inset As New FarPoint.Web.Spread.Inset(20,50,80,20)
Dim i As Integer
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Margin=inset
mycol.Resizable=False
For i=0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Next i

Reference

Column Class
Column Members

Product Support Forum | Print this page