Gets the string value for a custom name on this sheet from the model.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim name As String
Dim baseRow As Integer
Dim baseColumn As Integer
Dim value As String
value = instance.GetCustomName(name, baseRow, baseColumn) |
Parameters
- name
- Custom name to get
- baseRow
- Base row index for calculating relative row references in the value
- baseColumn
- Base column index for calculating relative column references in the value
Return Value
String containing the custom name
Remarks
Example
This example illustrates the use of this member by returning the string value for a custom name from the sheet.
C# | Copy Code |
---|
fpSpread1.ActiveSheet.AddCustomName("Alpha", "Sum(A1,A2)", 1, 1);
fpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha");
fpSpread1.ActiveSheet.SetValue(0, 0, 10);
fpSpread1.ActiveSheet.SetValue(1, 0, 10);
label1.Text = fpSpread1.ActiveSheet.GetCustomName("Alpha", 1, 1).ToString(); |
Visual Basic | Copy Code |
---|
FpSpread1.ActiveSheet.AddCustomName("Alpha", "Sum(A1,A2)", 1, 1)
FpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha")
FpSpread1.ActiveSheet.SetValue(0, 0, 10)
FpSpread1.ActiveSheet.SetValue(1, 0, 10)
Label1.Text = FpSpread1.ActiveSheet.GetCustomName("Alpha", 1, 1).ToString()
|
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also