SetCustomName(String,Int32,Int32,CalcExpression) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetCustomName( _
   ByVal name As System.String, _
   ByVal baseRow As System.Integer, _
   ByVal baseColumn As System.Integer, _
   ByVal expression As CalcExpression _
)

'Usage
 
Dim instance As Worksheet
Dim name As System.String
Dim baseRow As System.Integer
Dim baseColumn As System.Integer
Dim expression As CalcExpression
 
instance.SetCustomName(name, baseRow, baseColumn, expression)

public void SetCustomName( 
   System.string name,
   System.int baseRow,
   System.int baseColumn,
   CalcExpression expression
)

Parameters

name: The custom name.
baseRow: The base row.
baseColumn: The base column.
expression: The expression to set.

This example uses the SetCustomName method.

C#

gcSpreadSheet1.Sheets[0].SetValue(0, 0, 1);
gcSpreadSheet1.Sheets[0].SetValue(0, 1, 2);
gcSpreadSheet1.Sheets[0].SetValue(0, 2, 3);
gcSpreadSheet1.Sheets[0].SetCustomName("customName1", 0, 0, new CalcDoubleExpression(12));
gcSpreadSheet1.Sheets[0].SetCustomName("customName2", 0, 0, "Average(20,45)");
gcSpreadSheet1.Sheets[0].SetCustomName("customName3", 0, 0, 1, 3);
gcSpreadSheet1.Sheets[0].SetFormula(1, 0, "customName1");
gcSpreadSheet1.Sheets[0].SetFormula(1, 1, "customName2");
gcSpreadSheet1.Sheets[0].SetFormula(1, 2, "sum(customName3)");

VB.NET

GcSpreadSheet1.Sheets(0).SetValue(0, 0, 1)
GcSpreadSheet1.Sheets(0).SetValue(0, 1, 2)
GcSpreadSheet1.Sheets(0).SetValue(0, 2, 3)
GcSpreadSheet1.Sheets(0).SetCustomName("customName1", 0, 0, New CalcDoubleExpression(12))
GcSpreadSheet1.Sheets(0).SetCustomName("customName2", 0, 0, "Average(20,45)")
GcSpreadSheet1.Sheets(0).SetCustomName("customName3", 0, 0, 1, 3)
GcSpreadSheet1.Sheets(0).SetFormula(1, 0, "customName1")
GcSpreadSheet1.Sheets(0).SetFormula(1, 1, "customName2")
GcSpreadSheet1.Sheets(0).SetFormula(1, 2, "sum(customName3)")

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

Reference

Worksheet Class
Worksheet Members
Overload List