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


In This Topic
    FormatString Property (GeneralCellType)
    In This Topic
    Gets or sets the format string used to format the value.
    Syntax
    'Declaration
     
    Public Overridable Property FormatString As String
    'Usage
     
    Dim instance As GeneralCellType
    Dim value As String
     
    instance.FormatString = value
     
    value = instance.FormatString
    public virtual 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
    System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
    dtf.LongDatePattern = "D";
    dtf.ShortDatePattern = "M/d/yyyy";
    FarPoint.Web.Spread.GeneralCellType g = new FarPoint.Web.Spread.GeneralCellType();
    g.DateTimeFormat = dtf;
    g.FormatString = dtf.ShortDatePattern
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = g;
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    
    Dim dtf As New System.Globalization.DateTimeFormatInfo
    Dim b As Boolean
    dtf.LongDatePattern = "D"
    dtf.ShortDatePattern = "M/d/yyyy"
    Dim g As New FarPoint.Web.Spread.GeneralCellType
    g.DateTimeFormat = dtf
    g.FormatString = dtf.ShortDatePattern
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = g
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    See Also