AddCustomName(String,String,Int32,Int32) Method

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

Syntax

Visual Basic
C#

'Declaration
 
Overloads Sub AddCustomName( _
   ByVal name As String, _
   ByVal value As String, _
   ByVal baseRow As Integer, _
   ByVal baseColumn As Integer _
)

'Usage
 
Dim instance As ICustomNameSupport
Dim name As String
Dim value As String
Dim baseRow As Integer
Dim baseColumn As Integer
 
instance.AddCustomName(name, value, baseRow, baseColumn)

void AddCustomName( 
   string name,
   string value,
   int baseRow,
   int baseColumn
)

Parameters

name: Name to add
value: Value for name, as string
baseRow: Base row index for calculating relative row references in the value
baseColumn: Base column index for calculating relative column references in the value

Example

FarPoint.Web.Spread.Model.ICustomNameSupport cns; 
cns = (FarPoint.Web.Spread.Model.ICustomNameSupport)FpSpread1.ActiveSheetView.DataModel; 
cns.AddCustomName("ALPHA", "SUM(A1,A2)", 1, 1); 
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA"); 
FpSpread1.ActiveSheetView.SetValue(0, 0, 10); 
FpSpread1.ActiveSheetView.SetValue(1, 0, 10);

Visual Basic

Dim cns As FarPoint.Web.Spread.Model.ICustomNameSupport
cns = FpSpread1.ActiveSheetView.DataModel
cns.AddCustomName("ALPHA", "SUM(A1,A2)", 1, 1)
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA")
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(1, 0, 10)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ICustomNameSupport Interface
ICustomNameSupport Members
Overload List