Gets an IEnumerator that enumerates through the names of the named expressions in the model.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Function GetCustomNameEnumerator() As IEnumerator |
Return Value
IEnumerator object containing the enumerator for the custom name
Example
This example illustrates the use of this member by returning an IEnumerator that enumerates through the names of the named expressions in the model.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10);
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1);
dataModel.AddCustomName("TwiceProduct", "2*A1*A2", 2, 2);
dataModel.SetFormula(1, 1, "TWICESUM");
dataModel.SetFormula(2, 2, "TwiceProduct");
dataModel.SetValue(0, 0, 10);
dataModel.SetValue(1, 0, 10);
fpSpread1.ActiveSheet.Models.Data = dataModel;
IEnumerator enm;
enm = dataModel.GetCustomNameEnumerator();
while (enm.MoveNext())
{
listBox1.Items.Add(enm.Current);
} |
| 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.AddCustomName("TwiceProduct", "2*A1*A2", 2, 2)
dataModel.SetFormula(1, 1, "TWICESUM")
dataModel.SetFormula(2, 2, "TwiceProduct")
dataModel.SetValue(0, 0, 10)
dataModel.SetValue(1, 0, 10)
FpSpread1.ActiveSheet.Models.Data = dataModel
Dim enm As IEnumerator
enm = dataModel.GetCustomNameEnumerator()
While enm.MoveNext()
ListBox1.Items.Add(enm.Current)
End While |
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
