Spread for ASP.NET 11 Product Documentation
Resizable Property (Column)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Column Class : Resizable Property
Gets or sets whether this column can be resized.
Syntax
'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;
}
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
See Also

Reference

Column Class
Column Members