Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / GeneralCellType Class / NumberFormat Property
Example


In This Topic
    NumberFormat Property (GeneralCellType)
    In This Topic
    Gets or sets a NumberFormatInfo object that defines the format for displaying a numeric value.
    Syntax
    'Declaration
     
    Public Overridable Property NumberFormat As NumberFormatInfo
    'Usage
     
    Dim instance As GeneralCellType
    Dim value As NumberFormatInfo
     
    instance.NumberFormat = value
     
    value = instance.NumberFormat
    public virtual NumberFormatInfo NumberFormat {get; set;}

    Property Value

    NumberFormatInfo object containing the format for numeric values
    Example
    This example specifies a NumberFormatInfo which is used to format a currency value.
    FarPoint.Win.Spread.CellType.GeneralCellType genlcell = new FarPoint.Win.Spread.CellType.GeneralCellType();
    System.Globalization.NumberFormatInfo numform = (System.Globalization.NumberFormatInfo)System.Globalization.NumberFormatInfo.CurrentInfo.Clone();
    numform.CurrencySymbol = "\xA3";   
    Decimal myCurrency = new Decimal( 123456 );
    genlcell.NumberFormat = numform;
    genlcell.NegativeRed = true;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = genlcell;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = myCurrency.ToString( "C", numform );
    Dim genlcell As New FarPoint.Win.Spread.CellType.GeneralCellType()
    Dim numform As System.Globalization.NumberFormatInfo = CType(System.Globalization.NumberFormatInfo.CurrentInfo.Clone(), System.Globalization.NumberFormatInfo)
    numform.CurrencySymbol = Chr(163)
    Dim myCurrency As New (Decimal)(123456)
    genlcell.NumberFormat = numform
    genlcell.NegativeRed = True
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = g
    FpSpread1.ActiveSheet.Cells(0, 0).Value = myCurrency.ToString("C", numform)
    See Also