PowerTools SPREAD for Windows Forms 10.0J
FractionConvertWholeNumbers プロパティ


値が分数として表示される場合に整数を分数に変換するかどうかを取得または設定します。
構文
'Declaration
 
Public Overridable Property FractionConvertWholeNumbers As Boolean
'使用法
 
Dim instance As NumberCellType
Dim value As Boolean
 
instance.FractionConvertWholeNumbers = value
 
value = instance.FractionConvertWholeNumbers
public virtual bool FractionConvertWholeNumbers {get; set;}

プロパティ値

Boolean:整数を分数に変換する場合はTrue、それ以外の場合はFalse
次のサンプルコードは、セルの値を分数で表示します。
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
参照

NumberCellType クラス
NumberCellType メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.