Gets a named expression from the model.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Function GetCustomName( _
ByVal name As String _
) As Expression |
Parameters
- name
- Custom name to get
Return Value
Expression containing the custom name, or null if none existsExample
This example illustrates the use of this member by returning a custom name, as expression, from the model.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1);
dataModel.SetFormula(1, 1, "TWICESUM");
dataModel.SetValue(0, 0, 10);
dataModel.SetValue(1, 0, 10);
fpSpread1.ActiveSheet.Models.Data = dataModel;
listBox1.Items.Add(dataModel.GetCustomName("TWICESUM").ToString()); |
| Visual Basic | Copy Code |
|---|
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1)
dataModel.SetFormula(1, 1, "TWICESUM")
dataModel.SetValue(0, 0, 10)
dataModel.SetValue(1, 0, 10)
FpSpread1.ActiveSheet.Models.Data = dataModel
ListBox1.Items.Add(dataModel.GetCustomName("TWICESUM").ToString()) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
