Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / Resizable Property
Example


In This Topic
    Resizable Property (Column)
    In This Topic
    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