FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.Model 名前空間 > DefaultSheetDataModel クラス > AddModelScopeCustomName メソッド : AddModelScopeCustomName(String,String,Int32,Int32,String) メソッド |
'Declaration Public Overloads Sub AddModelScopeCustomName( _ ByVal name As String, _ ByVal value As String, _ ByVal baseRow As Integer, _ ByVal baseColumn As Integer, _ ByVal comment As String _ )
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5); dataModel.AddModelScopeCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1, "test"); dataModel.SetFormula(1, 1, "TWICESUM"); dataModel.SetValue(0, 0, 10); dataModel.SetValue(1, 0, 10); fpSpread1.ActiveSheet.Models.Data = dataModel;
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10) dataModel.AddModelScopeCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1, "test") dataModel.SetFormula(1, 1, "TWICESUM") dataModel.SetValue(0, 0, 10) dataModel.SetValue(1, 0, 10) FpSpread1.ActiveSheet.Models.Data = dataModel