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.Columnmycol;
FarPoint.Web.Spread.Insetinset=newFarPoint.Web.Spread.Inset(20,50,80,20);
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Margin=inset;
mycol.Resizable=false;
for(inti=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
DimmycolAsFarPoint.Web.Spread.Column
DiminsetAsNewFarPoint.Web.Spread.Inset(20,50,80,20)
DimiAsInteger
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Margin=inset
mycol.Resizable=False
Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
FpSpread1.ActiveSheetView.Rows(i).Height=80
Nexti |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
