Spread for ASP.NET 7.0 Product Documentation
GetCustomName(String,Int32,Int32) Method
See Also Example Support Options

FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class > GetCustomName Method : GetCustomName(String,Int32,Int32) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

name: Custom name to get

baseRow: Base row index for computing relative cell references

baseColumn: Base column index for computing relative cell references

Gets a named expression from the model with the specified base index for relative cell references.

Syntax

Visual Basic (Declaration)
Public Overloads Function GetCustomName( _ ByVal name As String, _ ByVal baseRow As Integer, _ ByVal baseColumn As Integer _ ) As String

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetDataModel Dim name As String Dim baseRow As Integer Dim baseColumn As Integer Dim value As String value = instance.GetCustomName(name, baseRow, baseColumn)

C#
public string GetCustomName( string name, int baseRow, int baseColumn )

Parameters

name: Custom name to get
baseRow: Base row index for computing relative cell references
baseColumn: Base column index for computing relative cell references

Return Value

String containing the custom name

Remarks

This method gets a custom name from the model with relative cell references.

Example

This example returns a custom name from the model.

C#	Copy Code
FarPoint.Web.Spread.Model.DefaultSheetDataModel 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"); string s; s = dataModel.GetCustomName("ALPHA", 1, 1).ToString(); Response.Write(s);

Copy Code

FarPoint.Web.Spread.Model.DefaultSheetDataModel 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");

string s;
s = dataModel.GetCustomName("ALPHA", 1, 1).ToString();
Response.Write(s);

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 s As String s = dataModel.GetCustomName("ALPHA", 1, 1) Response.Write(s)

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 s As String
s = dataModel.GetCustomName("ALPHA", 1, 1)
Response.Write(s)

Requirements

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