Spread Windows Forms 7.0 Product Documentation
AddCustomName(String,Expression) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class > AddCustomName Method : AddCustomName(String,Expression) Method


name
Custom name to add
value
Expression value for the custom name

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Overloads Sub AddCustomName( _
   ByVal name As String, _
   ByVal value As Expression _
) 
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim name As String
Dim value As Expression
 
instance.AddCustomName(name, value)
C# 
public void AddCustomName( 
   string name,
   Expression value
)

Parameters

name
Custom name to add
value
Expression value for the custom name

Example

This example adds a custom name, as an expression, to the model for use in formulas.
C#Copy Code
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
dataModel.AddCustomName("TWICESUM", new FarPoint.CalcEngine.DoubleExpression(10));
dataModel.SetFormula(1, 1, "TWICESUM");
fpSpread1.ActiveSheet.Models.Data = dataModel;
Visual BasicCopy Code
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
dataModel.AddCustomName("TWICESUM", New FarPoint.CalcEngine.DoubleExpression(10))
dataModel.SetFormula(1, 1, "TWICESUM")
FpSpread1.ActiveSheet.Models.Data = dataModel

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.