AddModelScopeCustomName(String,Expression,String) Method

Adds a new user-defined name for the specified value, as an expression, to the model.

Syntax

Visual Basic
C#

'Declaration
 
Overloads Sub AddModelScopeCustomName( _
   ByVal name As String, _
   ByVal value As Expression, _
   ByVal comment As String _
)

'Usage
 
Dim instance As IEnhancedCustomNameSupport
Dim name As String
Dim value As Expression
Dim comment As String
 
instance.AddModelScopeCustomName(name, value, comment)

void AddModelScopeCustomName( 
   string name,
   Expression value,
   string comment
)

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.

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

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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

IEnhancedCustomNameSupport Interface
IEnhancedCustomNameSupport Members
Overload List