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

In This Topic
    FormatString Property (GeneralCellType)
    In This Topic
    Gets or sets the format string used to format the value.
    Public Overridable Property FormatString As String
    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

    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.

    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