Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / LabelCellType Class / FormatString Property
Example


In This Topic
    FormatString Property (LabelCellType)
    In This Topic
    Gets and sets the format for the label.
    Syntax
    'Declaration
     
    Public Property FormatString As String
    'Usage
     
    Dim instance As LabelCellType
    Dim value As String
     
    instance.FormatString = value
     
    value = instance.FormatString
    public string FormatString {get; set;}

    Property Value

    String containing the format string
    Remarks

    The value of a general cell can be a string, a number, or a DateTime object.

    The formats supported are the numeric formats and date-time formats in .NET framework.

    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