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