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


In This Topic
    ParseFormatInfo Property
    In This Topic
    Gets or sets the parsed formatting for the cell.
    Syntax
    'Declaration
     
    Public Property ParseFormatInfo As IFormatProvider
    'Usage
     
    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
    Remarks
    This property is only for use with cells of type GeneralCellType.
    Example
    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