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


In This Topic
    CurrencySymbol Property (CurrencyCellType)
    In This Topic
    Gets or sets the string for the currency symbol when displaying currency values.
    Syntax
    'Declaration
     
    Public Property CurrencySymbol As String
    'Usage
     
    Dim instance As CurrencyCellType
    Dim value As String
     
    instance.CurrencySymbol = value
     
    value = instance.CurrencySymbol
    public string CurrencySymbol {get; set;}

    Property Value

    String containing the symbol for currency
    Example
    This example specifies a currency cell and sets the formatting using the various properties.
    FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
    currcell.CurrencySymbol = "CN$";
    currcell.DecimalPlaces = 4;
    currcell.DecimalSeparator = "#";
    currcell.FixedPoint = true;
    currcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes;
    currcell.MaximumValue = 999999999999;
    currcell.MinimumValue = 1;
    currcell.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolSpaceBefore;
    currcell.NegativeRed = true;
    currcell.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolBefore;
    currcell.Separator = ",";
    currcell.ShowCurrencySymbol = true;
    currcell.ShowSeparator = true;
    fpSpread1.Sheets[0].Cells[5,2].CellType = currcell;
    fpSpread1.Sheets[0].Cells[5,2].Value = 321.98;
    Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType()
    currcell.CurrencySymbol = "CN$"
    currcell.DecimalPlaces = 4
    currcell.DecimalSeparator = "#"
    currcell.FixedPoint = True
    currcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes
    currcell.MaximumValue = 999999999999
    currcell.MinimumValue = 1
    currcell.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolSpaceBefore
    currcell.NegativeRed = true
    currcell.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolBefore
    currcell.Separator = ","
    currcell.ShowCurrencySymbol = True
    currcell.ShowSeparator = True
    fpSpread1.Sheets(0).Cells(5, 2).CellType = currcell
    fpSpread1.Sheets(0).Cells(5, 2).Value = 443.3482
    See Also