Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / GetCustomName Method / GetCustomName(String) Method
Custom name to get
Example


In This Topic
    GetCustomName(String) Method
    In This Topic
    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())
    See Also