AddCustomName(String,Expression) Method

Adds a named expression to the model for use in formulas.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub AddCustomName( _
   ByVal name As String, _
   ByVal value As Expression _
)

'Usage
 
Dim instance As DefaultSheetDataModel
Dim name As String
Dim value As Expression
 
instance.AddCustomName(name, value)

public void AddCustomName( 
   string name,
   Expression value
)

Parameters

name: Name of the expression to add (used in formulas to reference the value)
value: Expression object to add

Remarks

Adds a named expression (for use in formulas) to the model.

Example

This example adds a custom name to the model using the specified expression value.

FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.AddCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20));
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA");

Visual Basic

Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.AddCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20))
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA")

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List