PowerTools SPREAD for ASP.NET 8.0J
GetCustomNameEnumerator メソッド (DefaultSheetDataModel)

モデル内の名前付きの式の名前を列挙するIEnumeratorを取得します。
構文
'Declaration
 
Public Function GetCustomNameEnumerator() As IEnumerator
public IEnumerator GetCustomNameEnumerator()

戻り値の型

カスタム名のIEnumerator設定
次のサンプルコードは、モデルからカスタム名を返します。
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; 
System.Collections.IEnumerator se; 
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1); 
dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2); 
FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM"); 
FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT"); 
FpSpread1.ActiveSheetView.SetValue(0, 0, 10); 
FpSpread1.ActiveSheetView.SetValue(1, 0, 10); 
se = dataModel.GetCustomNameEnumerator(); 
se.MoveNext(); 
Response.Write(se.Current.ToString());
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
Dim se As System.Collections.IEnumerator
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1)
dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2)
FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM")
FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT")
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(1, 0, 10)
se = dataModel.GetCustomNameEnumerator()

se.MoveNext()
Response.Write(se.Current.ToString())
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.