Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / PercentCellType Class / FixedPoint Property

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

    Property Value

    Boolean: true for fixed-point display with placeholder zeros; false otherwise
    This example sets the minimum and maximum values and how to display the percentage.
    FarPoint.Web.Spread.PercentCellType pctcell = new FarPoint.Web.Spread.PercentCellType();
    pctcell.MinimumValue = 0.151;    // 15.1%
    pctcell.MaximumValue = 0.94;   // 94.0%
    pctcell.DecimalDigits = 1;            // Show only one digit to right of decimal point.
    pctcell.FixedPoint = true;
    FpSpread1.ActiveSheetView.Cells[0, 1].CellType = pctcell;
    Dim pctcell As New FarPoint.Web.Spread.PercentCellType()
    pctcell.MinimumValue = 0.151 '15.1%
    pctcell.MaximumValue = 0.94 '94.0%
    pctcell.DecimalDigits = 1   'Show only one digit to right of decimal point.
    pctcell.FixedPoint = True
    FpSpread1.ActiveSheetView.Cells(0, 1).CellType = pctcell
    See Also