Spread Windows Forms 10.0 Product Documentation
FractionDenominatorPrecision Enumeration
Example Example 


Specifies the precision of the fraction denominator for numeric cells that display as fractions.
Syntax
'Declaration
 
Public Enum FractionDenominatorPrecision 
   Inherits System.Enum
'Usage
 
Dim instance As FractionDenominatorPrecision
public enum FractionDenominatorPrecision : System.Enum 
Members
MemberDescription
AutoSets the precision automatically.
CustomSets the precision to a custom value.
EighthsSets the precision to eighths.
HalvesSets the precision to halves.
HundredthsSets the precision to hundredths.
QuartersSets the precision to quarters.
SixteenthsSets the precision to sixteenths.
SixtyFourthsSets the precision to sixty-fourths.
TenthsSets the precision to tenths.
ThirtySecondsSets the precision to thirty-seconds.
ThousandthsSets 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;
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

See Also

Reference

FarPoint.Win.Spread.CellType Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.