GetCustomName(String) Method

Gets the expression value for a custom name on this sheet from the model.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetCustomName( _
   ByVal name As String _
) As Expression

'Usage
 
Dim instance As SheetView
Dim name As String
Dim value As Expression
 
value = instance.GetCustomName(name)

public Expression GetCustomName( 
   string name
)

Parameters

name: Custom name to get

Example

This example uses the GetCustomName method.

FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel();
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.AddCustomName("ALPHA", "SUM(A1, A2)", 1, 1);
FpSpread1.ActiveSheetView.SetValue(0, 0, 10);
FpSpread1.ActiveSheetView.SetValue(1, 0, 100);
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA");
TextBox1.Text = FpSpread1.ActiveSheetView.GetCustomName("ALPHA").ToString();

Visual Basic

Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel()
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.AddCustomName("ALPHA", "SUM(A1, A2)", 1, 1)
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(1, 0, 100)
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA")
TextBox1.Text = FpSpread1.ActiveSheetView.GetCustomName("ALPHA").ToString()

Reference

SheetView Class
SheetView Members
Overload List