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


In This Topic
    FractionDenominatorDigits Property
    In This Topic
    Gets or sets the number of digits when values are displayed as fractions.
    Syntax
    'Declaration
     
    Public Overridable Property FractionDenominatorDigits As Integer
    'Usage
     
    Dim instance As NumberCellType
    Dim value As Integer
     
    instance.FractionDenominatorDigits = value
     
    value = instance.FractionDenominatorDigits
    public virtual int FractionDenominatorDigits {get; set;}

    Property Value

    Integer number of digits
    Example
    This example displays the value in the cell as a fraction.
    FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType(); 
    n.FractionMode = true; 
    n.FractionConvertWholeNumbers = true; 
    n.DecimalPlaces = 2; 
    n.FractionDenominatorDigits = 2; 
    n.FractionCustomFormat = "# ??/??"; 
    n.FractionDenominatorPrecision = FarPoint.Win.Spread.CellType.FractionDenominatorPrecision.Hundredths; 
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = n; 
    fpSpread1.ActiveSheet.Cells[0, 0].Value = 5.005;
    
    Dim n As New FarPoint.Win.Spread.CellType.NumberCellType
    n.FractionMode = True
    n.FractionConvertWholeNumbers = True
    n.DecimalPlaces = 2
    n.FractionDenominatorDigits = 2
    n.FractionCustomFormat = "# ??/??"
    n.FractionDenominatorPrecision = FarPoint.Win.Spread.CellType.FractionDenominatorPrecision.Hundredths
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = n
    FpSpread1.ActiveSheet.Cells(0, 0).Value = 5
    
    See Also