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


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

    Property Value

    FractionDenominatorPrecision setting that determines the precision for fractions
    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