Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / ParseFormatString Property

In This Topic
    ParseFormatString Property
    In This Topic
    Gets or sets the parsed formatting string for the cell.
    Public Property ParseFormatString As String
    Dim instance As Cell
    Dim value As String
    instance.ParseFormatString = value
    value = instance.ParseFormatString
    public string ParseFormatString {get; set;}

    Property Value

    String containing the parsed formatting string
    This property is only for use with cells of type GeneralCellType.
    This example shows how to parse cell data.
    FarPoint.Win.Spread.CellType.GeneralCellType gct = new FarPoint.Win.Spread.CellType.GeneralCellType();
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = gct;
    System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-us", true);
    fpSpread1.ActiveSheet.Cells[0, 0].Value = System.DateTime.Now;
    fpSpread1.ActiveSheet.Cells[0, 0].ParseFormatString = ci.DateTimeFormat.ToString();
    Dim gct As New FarPoint.Win.Spread.CellType.GeneralCellType
    Dim ci As New System.Globalization.CultureInfo("en-us", True)
    fpSpread1.ActiveSheet.Cells(0, 0).CellType = gct
    fpSpread1.ActiveSheet.Cells(0, 0).Value = Now
    fpSpread1.ActiveSheet.Cells(0, 0).ParseFormatString = ci.DateTimeFormat.ToString()
    See Also