Spread for ASP.NET 8.0 Product Documentation
AddCustomName(String,Expression) Method
Example 


Name of the expression to add (used in formulas to reference the value)
Expression object to add
Adds a named expression to the model for use in formulas.
Syntax
'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");
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

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.