FractionDenominatorPrecision Enumeration

Specifies the precision of the fraction denominator for numeric cells that display as fractions.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum FractionDenominatorPrecision 
   Inherits System.Enum

'Usage
 
Dim instance As FractionDenominatorPrecision

public enum FractionDenominatorPrecision : System.Enum

Members

Member	Description
Auto	Sets the precision automatically.
Custom	Sets the precision to a custom value.
Eighths	Sets the precision to eighths.
Halves	Sets the precision to halves.
Hundredths	Sets the precision to hundredths.
Quarters	Sets the precision to quarters.
Sixteenths	Sets the precision to sixteenths.
SixtyFourths	Sets the precision to sixty-fourths.
Tenths	Sets the precision to tenths.
ThirtySeconds	Sets the precision to thirty-seconds.
Thousandths	Sets the precision to thousandths.

Example

This example creates a number cell.

FarPoint.Win.Spread.CellType.NumberCellType n = new FarPoint.Win.Spread.CellType.NumberCellType();
n.FractionMode = true;            
n.DecimalPlaces = 2;
n.FractionDenominatorDigits = 2;
n.FractionCustomFormat = "# ??/??";
n.FractionRenderOnly = true;
n.FractionDenominatorPrecision = FarPoint.Win.Spread.CellType.FractionDenominatorPrecision.Hundredths;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = n;
fpSpread1.ActiveSheet.Cells[0, 0].Value = 5.004;

Visual Basic

Dim n As New FarPoint.Win.Spread.CellType.NumberCellType()
n.FractionMode = True        
n.DecimalPlaces = 2
n.FractionDenominatorDigits = 2
n.FractionCustomFormat = "# ??/??"
n.FractionRenderOnly = True
n.FractionDenominatorPrecision = FarPoint.Win.Spread.CellType.FractionDenominatorPrecision.Hundredths
fpSpread1.ActiveSheet.Cells(0, 0).CellType = n
fpSpread1.ActiveSheet.Cells(0, 0).Value = 5.004

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellType.FractionDenominatorPrecision

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread.CellType Namespace