GetModelScopeCustomName(String,Int32,Int32) Method

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function GetModelScopeCustomName( _
   ByVal name As String, _
   ByVal baseRow As Integer, _
   ByVal baseColumn As Integer _
) As String

'Usage
 
Dim instance As DefaultSheetDataModel
Dim name As String
Dim baseRow As Integer
Dim baseColumn As Integer
Dim value As String
 
value = instance.GetModelScopeCustomName(name, baseRow, baseColumn)

public string GetModelScopeCustomName( 
   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

Example

This example uses the GetModelScopeCustomName method.

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
dataModel.AddModelScopeCustomName("TWICESUM", new FarPoint.CalcEngine.DoubleExpression(10), "test");
dataModel.SetFormula(1, 1, "TWICESUM");
fpSpread1.ActiveSheet.Models.Data = dataModel;
listBox1.Items.Add(dataModel.GetModelScopeCustomName("TWICESUM", 1, 1).ToString());
listBox1.Items.Add(dataModel.GetModelScopeCustomName("TWICESUM").ToString());

VB.NET

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
dataModel.AddModelScopeCustomName("TWICESUM", New FarPoint.CalcEngine.DoubleExpression(10), "test")
dataModel.SetFormula(1, 1, "TWICESUM")
FpSpread1.ActiveSheet.Models.Data = dataModel
ListBox1.Items.Add(dataModel.GetModelScopeCustomName("TWICESUM", 1, 1).ToString())
ListBox1.Items.Add(dataModel.GetModelScopeCustomName("TWICESUM").ToString())

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List