Gets a named expression from the model.

Syntax

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

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim name As String Dim value As Expression value = instance.GetCustomName(name)

C#
public Expression GetCustomName( string name )

Parameters

name: Custom name to get

Return Value

Expression containing the custom name

Remarks

This method gets a named expression from the model.

Example

This example returns a custom name from the model.

C#	Copy Code
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"); FarPoint.CalcEngine.Expression ex; ex = dataModel.GetCustomName("ALPHA"); Response.Write(ex.ToString());

Copy Code

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");

FarPoint.CalcEngine.Expression ex;
ex = dataModel.GetCustomName("ALPHA");
Response.Write(ex.ToString());

Visual Basic	Copy Code
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") Dim ex As FarPoint.CalcEngine.Expression ex = dataModel.GetCustomName("ALPHA") Response.Write(ex.ToString())

Visual Basic

Copy Code

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")

Dim ex As FarPoint.CalcEngine.Expression
ex = dataModel.GetCustomName("ALPHA")
Response.Write(ex.ToString())

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family