MESCIUS SPREAD for Windows Forms 15.0J
RoundPattern プロパティ (GcNumberCellType)
使用例 

値の端数処理を取得または設定します。
構文
'宣言
 
Public Property RoundPattern As RoundPattern
public RoundPattern RoundPattern {get; set;}

プロパティ値

値の端数処理を取得または設定しますRoundPattern値。
使用例
次のサンプルコードは、値を丸めます。
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.Fields.SetFields("###.#", "", "", "-", "");
ncell1.RoundPattern = GrapeCity.Win.Spread.InputMan.CellType.RoundPattern.Ceiling;            
fpSpread1.ActiveSheet.Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 12.31;
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.Fields.SetFields("###.#", "", "", "-", "")
ncell1.RoundPattern = GrapeCity.Win.Spread.InputMan.CellType.RoundPattern.Ceiling
fpSpread1.ActiveSheet.Cells(1, 1).CellType = ncell1
fpSpread1.ActiveSheet.Cells(1, 1).Value = 12.31
参照

GcNumberCellType クラス
GcNumberCellType メンバ

 

 


© MESCIUS inc. All rights reserved.