Adds a named expression to the model scope for use in formulas.
Syntax
Parameters
- name
- Name of the expression to add (used in formulas to reference the value)
- value
- Expression object to add
- comment
- Comment of custom name to add
Example
This example uses the AddModelScopeCustomName 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;
//dataModel.RemoveModelScopeCustomName("TWICESUM"); |
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
'dataModel.RemoveModelScopeCustomName("TWICESUM") |
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