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


In This Topic
    FractionMode Property
    In This Topic
    Gets or sets whether values are represented as fractions.
    Syntax
    'Declaration
     
    Public Overridable Property FractionMode As Boolean
    'Usage
     
    Dim instance As NumberCellType
    Dim value As Boolean
     
    instance.FractionMode = value
     
    value = instance.FractionMode
    public virtual bool FractionMode {get; set;}

    Property Value

    Boolean: true to display values as fractions; false otherwise
    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