Adds a custom name to the model using the specified expression value.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim name As String
Dim value As Expression
Dim sheetViewScope As Boolean
Dim comment As String
instance.AddCustomName(name, value, sheetViewScope, comment) |
Parameters
- name
- Custom name to add
- value
- Expression value for the custom name
- sheetViewScope
- comment
- Comment for the custom name
Example
This example uses the AddCustomName method.
| C# | Copy Code |
|---|
fpSpread1.ActiveSheet.AddCustomName("Alpha", new FarPoint.CalcEngine.DoubleExpression(20), false, "Extra information");
fpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha");
listBox1.Items.Add(fpSpread1.ActiveSheet.GetCustomName("Alpha", false));
listBox1.Items.Add(fpSpread1.ActiveSheet.GetCustomName("Alpha", 0, 0, false));
listBox1.Items.Add(fpSpread1.ActiveSheet.GetCustomNameComment("Alpha", false)); |
| VB.NET | Copy Code |
|---|
FpSpread1.ActiveSheet.AddCustomName("Alpha", New FarPoint.CalcEngine.DoubleExpression(20), False, "Extra information")
FpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha")
ListBox1.Items.Add(FpSpread1.ActiveSheet.GetCustomName("Alpha", False))
ListBox1.Items.Add(FpSpread1.ActiveSheet.GetCustomName("Alpha", 0, 0, False))
ListBox1.Items.Add(FpSpread1.ActiveSheet.GetCustomNameComment("Alpha", False)) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
