Spread for ASP.NET 9.0 Product Documentation
GetCustomName(String) Method
Example 


Custom name to get
Gets a named expression from the model.
Syntax
'Declaration
 
Public Overloads Function GetCustomName( _
   ByVal name As String _
) As Expression
'Usage
 
Dim instance As DefaultSheetDataModel
Dim name As String
Dim value As Expression
 
value = instance.GetCustomName(name)
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.
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());
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 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.