FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class > AddModelScopeCustomName Method : AddModelScopeCustomName(String,String,Int32,Int32,String) Method |
'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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8