Gets or sets whether this column can be resized.
Syntax
Visual Basic (Declaration) | |
---|
Public Property Resizable As Boolean |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As Column
Dim value As Boolean
instance.Resizable = value
value = instance.Resizable |
C# | |
---|
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.
C# | Copy Code |
---|
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 | Copy Code |
---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also