FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel 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
'Usage Dim instance As DefaultSheetDataModel Dim name As String Dim baseRow As Integer Dim baseColumn As Integer Dim value As String value = instance.GetCustomName(name, 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; listBox1.Items.Add(dataModel.GetCustomName("TWICESUM", 1, 1).ToString());
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 ListBox1.Items.Add(dataModel.GetCustomName("TWICESUM", 1, 1).ToString())
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8