PowerTools SPREAD for Windows Forms 10.0J
ReferenceStyle プロパティ (DefaultSheetDataModel)


数式を含むセルのセル参照スタイルを 取得または設定します。
構文
'Declaration
 
Public Property ReferenceStyle As ReferenceStyle
'使用法
 
Dim instance As DefaultSheetDataModel
Dim value As ReferenceStyle
 
instance.ReferenceStyle = value
 
value = instance.ReferenceStyle
public ReferenceStyle ReferenceStyle {get; set;}

プロパティ値

セル参照スタイルを決定するReferenceStyle設定
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
dataModel.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
dataModel.SetValue(0, 0, 5)
dataModel.SetValue(1, 0, 5)
dataModel.SetFormula(0, 0, "3*SUM(A1,B1)")
FpSpread1.ActiveSheet.Models.Data = dataModel
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(3, 3);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
dataModel.SetValue(0, 0, 5);
dataModel.SetValue(1, 0, 5);
dataModel.SetFormula(0, 0, "3*SUM(A1,B1)");
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


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