Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType 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

    The value of a general cell can be a string, a number, or a DateTime object. The general cell does not support a format string using "r" or "R".

    The formats supported are the NumberFormatInfo object and the DateTimeFormatInfo object that can be found in the Microsoft .NET framework SDK documentation. Discussion of these formats are in the numeric formats and date-time formats topics in the Microsoft .NET Developer's Guide.

    This example specifies the format string used to format the date value.
    FarPoint.Win.Spread.CellType.GeneralCellType genlcell = new FarPoint.Win.Spread.CellType.GeneralCellType();
    genlcell.FormatString = "dd/MM/yyyy";
    genlcell.IsDateFormat = true;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = genlcell;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = DateTime.Now;
    Dim genlcell As New FarPoint.Win.Spread.CellType.GeneralCellType()
    genlcell.FormatString = "dd/MM/yyyy"
    genlcell.IsDateFormat = True
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = genlcell
    FpSpread1.ActiveSheet.Cells(0, 0).Value = DateTime.Now
    See Also