Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / GeneralCellType Class / AllowWrap Property
Example


In This Topic
    AllowWrap Property (GeneralCellType)
    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 Overridable Property AllowWrap As Boolean
    'Usage
     
    Dim instance As GeneralCellType
    Dim value As Boolean
     
    instance.AllowWrap = value
     
    value = instance.AllowWrap
    public virtual bool AllowWrap {get; set;}

    Property Value

    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 new GeneralCellType object, sets its Size and AllowWrap properties and then assigns the object to the first cell in the spreadsheet.
    FarPoint.Web.Spread.GeneralCellType icell=new FarPoint.Web.Spread.GeneralCellType();
    string Str;
    Str="This is a test for a GeneralCellType. Its size has been set to 20 and text should wrap to multiple lines.";
    icell.AllowWrap=True;
    icell.Size=90;
    FpSpread1.ActiveSheetView.Cells[0,0].CellType=icell;
    FpSpread1.ActiveSheetView.SetValue(0,0,Str);
    FpSpread1.Sheets[0].Columns[0].Width=120;
    FpSpread1.Sheets[0].Rows[0].Height=120;
    Dim icell As New FarPoint.Web.Spread.GeneralCellType()
    Dim Str As String
    Str="This is a test for a GeneralCellType. Its size has been set to 20 and text should wrap to multiple lines."
    icell.AllowWrap=True
    icell.Size=90
    FpSpread1.ActiveSheetView.Cells(0,0).CellType=icell
    FpSpread1.ActiveSheetView.SetValue(0,0,Str)
    FpSpread1.Sheets(0).Columns(0).Width=120
    FpSpread1.Sheets(0).Rows(0).Height=120
    See Also