Adds a new user-defined name for the specified value, as an expression, to the model.
Syntax
Parameters
- name
- The name of custom name to add
- value
- The value of custom name to add
- comment
- The comment of the custom name to add
Example
This example uses the AddModelScopeCustomName method.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.IEnhancedCustomNameSupport cns;
FarPoint.CalcEngine.Expression ex;
cns = (FarPoint.Win.Spread.Model.IEnhancedCustomNameSupport)fpSpread1.ActiveSheet.Models.Data;
cns.AddModelScopeCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20), "test");
fpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA");
ex = cns.GetModelScopeCustomName("ALPHA");
listBox1.Items.Add("The type of the custom name is " + ex.ToString()); |
VB.NET | Copy Code |
---|
Dim cns As FarPoint.Win.Spread.Model.IEnhancedCustomNameSupport
Dim ex As FarPoint.CalcEngine.Expression
cns = FpSpread1.ActiveSheet.Models.Data
cns.AddModelScopeCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20), "test")
FpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA")
ex = cns.GetModelScopeCustomName("ALPHA")
ListBox1.Items.Add("The type of the custom name is " & ex.ToString()) |
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