Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / TextCellType Class / Size Property
Example


In This Topic
    Size Property (TextCellType)
    In This Topic
    Gets or sets the size of the text box in characters.
    Syntax
    'Declaration
     
    
    Public Property Size As Integer
    'Usage
     
    
    Dim instance As TextCellType
    Dim value As Integer
     
    instance.Size = value
     
    value = instance.Size
    public int Size {get; set;}

    Property Value

    Integer number of characters in the text box
    Remarks
    The value for this property must be greater than zero.
    Example
    This example creates a new TextCellType object, sets its Size and AllowWrap properties and then assigns the object to the first cell in the spreadsheet.
    Dim tcell As New FarPoint.Web.Spread.TextCellType()
    Dim Str As String
    Str="This is a test for a TextCellType. Its size has been set to 20 and text should wrap to multiple lines."
    tcell.AllowWrap=True
    tcell.Size=90
    FpSpread1.ActiveSheetView.Cells(0,0).CellType=tcell
    FpSpread1.ActiveSheetView.SetValue(0,0,Str)
    FpSpread1.Sheets(0).Columns(0).Width=120
    FpSpread1.Sheets(0).Rows(0).Height=120
    FarPoint.Web.Spread.TextCellType tcell=new FarPoint.Web.Spread.TextCellType();
    string Str;
    Str="This is a test for a TextCellType. The size has been set to 20 and text should wrap to multiple lines.";
    tcell.AllowWrap=True;
    tcell.Size=90;
    FpSpread1.ActiveSheetView.Cells[0,0].CellType=tcell;
    FpSpread1.ActiveSheetView.SetValue(0,0,Str);
    FpSpread1.Sheets[0].Columns[0].Width=120;
    FpSpread1.Sheets[0].Rows[0].Height=120;
    See Also