Spread ASP.NET 18
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / Resizable Property
Example


In This Topic
    Resizable Property (Row)
    In This Topic
    Gets or sets whether this row can be resized.
    Syntax
    'Declaration
     
    
    Public Property Resizable As Boolean
    'Usage
     
    
    Dim instance As Row
    Dim value As Boolean
     
    instance.Resizable = value
     
    value = instance.Resizable
    public bool Resizable {get; set;}

    Property Value

    true if the user can resize this row; false otherwise
    Example
    This example creates a spreadsheet with 10 Columns and 20 Rows. A Row object is created and assigned to the second row. Text and margins are set for the cells in the row 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.Row myrow;
    FarPoint.Web.Spread.Inset inset=new FarPoint.Web.Spread.Inset(20,50,80,20);
    myrow=FpSpread1.ActiveSheetView.Rows[1];
    myrow.Margin=inset;
    myrow.Resizable=false;
    FpSpread1.ActiveSheetView.Columns[1].Width=140;
    for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
    {
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment");
    }
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim myrow As FarPoint.Web.Spread.Row
    Dim inset As New FarPoint.Web.Spread.Inset(20,50,80,20)
    Dim row,i As Integer
    row=1
    myrow=FpSpread1.ActiveSheetView.Rows(row)
    myrow.Margin=inset
    myrow.Resizable=False
    FpSpread1.ActiveSheetView.Columns(1).Width=140
    For i=0 To FpSpread1.ActiveSheetView.RowCount-1
    FpSpread1.ActiveSheetView.SetValue(i,1,"Alignment")
    Next i
    See Also