Spread Windows Forms 11.0 Product Documentation
AddCustomName(String,Expression) Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ICustomNameSupport Interface > AddCustomName Method : AddCustomName(String,Expression) Method
Name to add
Value for name, as expression
Adds a new user-defined name for the specified value, as an expression, to the model.
Syntax
'Declaration
 
Overloads Sub AddCustomName( _
   ByVal name As String, _
   ByVal value As Expression _
) 
'Usage
 
Dim instance As ICustomNameSupport
Dim name As String
Dim value As Expression
 
instance.AddCustomName(name, value)
void AddCustomName( 
   string name,
   Expression value
)

Parameters

name
Name to add
value
Value for name, as expression
Example
This example adds a named expression to the sheet for use in formulas.
FarPoint.Win.Spread.Model.ICustomNameSupport cns;
cns = (FarPoint.Win.Spread.Model.ICustomNameSupport)fpSpread1.ActiveSheet.Models.Data;
cns.AddCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20));
fpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA");
Dim cns As FarPoint.Win.Spread.Model.ICustomNameSupport
cns = FpSpread1.ActiveSheet.Models.Data
cns.AddCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20))
FpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA")
See Also

Reference

ICustomNameSupport Interface
ICustomNameSupport Members
Overload List