Gets a named expression from the model with the specified base index for relative cell references.
Syntax
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.
C# | Copy Code |
---|
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 | Copy Code |
---|
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()) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also