Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / LabelCellType Class / AllowWrap Property
Example


In This Topic
    AllowWrap Property (LabelCellType)
    In This Topic
    Gets or sets whether the cell allows text to wrap to multiple lines. Wrapping only occurs on word breaks.
    Syntax
    'Declaration
     
    Public Property AllowWrap As Boolean
    'Usage
     
    Dim instance As LabelCellType
    Dim value As Boolean
     
    instance.AllowWrap = value
     
    value = instance.AllowWrap
    public bool AllowWrap {get; set;}

    Property Value

    Boolean: true to allow wrapping to multiple lines; false otherwise
    Remarks

    When this property is set to true, text is wrapped when it is wider that the width of the cell. When this property is set to false, text that is wider than the cell is not displayed in the cell.

    Wrapping only occurs on word breaks.

    Example
    This example creates a LabelCellType object, allows its text to wrap if long enough and sets up the formatting for the text. It is assigned to the first cell in the sheet.
    FarPoint.Web.Spread.LabelCellType lblcell=new FarPoint.Web.Spread.LabelCellType();
    lblcell.AllowWrap=true;
    int i=100;
    string fstring=i.ToString("C");
    lblcell.FormatString=fstring;
    FpSpread1.ActiveSheetView.Cells[0,0].CellType=lblcell;
    FpSpread1.ActiveSheetView.Cells[0,0].Text=fstring;
    Dim lblcell As New FarPoint.Web.Spread.LabelCellType()
    lblcell.AllowWrap=True
    Dim i As Integer=100
    Dim fstring As String=i.ToString("C")
    lblcell.FormatString=fstring
    FpSpread1.ActiveSheetView.Cells(0,0).CellType=lblcell
    FpSpread1.ActiveSheetView.Cells(0,0).Text=fstring
    See Also