FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class > AddCustomName Method : AddCustomName(String,String,Int32,Int32) Method |
'Declaration Public Overloads Sub AddCustomName( _ ByVal name As String, _ ByVal value As String, _ ByVal baseRow As Integer, _ ByVal baseColumn As Integer _ )
'Usage 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.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel; dataModel.AddCustomName("ALPHA", "SUM(A1, A2)", 1, 1); FpSpread1.ActiveSheetView.SetValue(0, 0, 10); FpSpread1.ActiveSheetView.SetValue(1, 0, 100); FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA");
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = FpSpread1.ActiveSheetView.DataModel dataModel.AddCustomName("ALPHA", "SUM(A1, A2)", 1, 1) FpSpread1.ActiveSheetView.SetValue(0, 0, 10) FpSpread1.ActiveSheetView.SetValue(1, 0, 100) FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA")
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6