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

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

    Property Value

    IFormatProvider object containing the way to control formatting
    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();
    gct.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDate;
    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].ParseFormatInfo = ci;
    Dim gct As New FarPoint.Win.Spread.CellType.GeneralCellType
    gct.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDate
    fpSpread1.ActiveSheet.Cells(0, 0).CellType = gct
    Dim ci As New System.Globalization.CultureInfo("en-us", True)
    fpSpread1.ActiveSheet.Cells(0, 0).Value = Now
    fpSpread1.ActiveSheet.Cells(0, 0).ParseFormatInfo = ci
    See Also