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


In This Topic
    FixedPoint Property (CurrencyCellType)
    In This Topic
    Gets or sets whether to display zeros as placeholders in the decimal portion of the number for a fixed-point numeric display.
    Syntax
    'Declaration
     
    Public Property FixedPoint As Boolean
    'Usage
     
    Dim instance As CurrencyCellType
    Dim value As Boolean
     
    instance.FixedPoint = value
     
    value = instance.FixedPoint
    public bool FixedPoint {get; set;}

    Property Value

    Boolean: true displays place-holding zeros in the decimal portion; false does not
    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