FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > GetCustomName Method : GetCustomName(String,Int32,Int32) Method |
'Declaration Public Overloads Function GetCustomName( _ ByVal name As String, _ ByVal baseRow As Integer, _ ByVal baseColumn As Integer _ ) As String
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"); TextBox1.Text = FpSpread1.ActiveSheetView.GetCustomName("ALPHA", 0, 0).ToString();
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") TextBox1.Text = FpSpread1.ActiveSheetView.GetCustomName("ALPHA", 0, 0).ToString()
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional