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


In This Topic
    FractionCustomFormat Property
    In This Topic
    Gets or sets how values are displayed as fractions with custom formatting.
    Syntax
    'Declaration
     
    Public Overridable Property FractionCustomFormat As String
    'Usage
     
    Dim instance As NumberCellType
    Dim value As String
     
    instance.FractionCustomFormat = value
     
    value = instance.FractionCustomFormat
    public virtual string FractionCustomFormat {get; set;}

    Property Value

    String containing the formatting
    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