Spread for ASP.NET 8.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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.