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 setting for the custom name
Example
This example returns a custom name from the model.
| C# |  Copy Code |
|---|
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
System.Collections.IEnumerator se;
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1);
dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2);
FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM");
FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT");
FpSpread1.ActiveSheetView.SetValue(0, 0, 10);
FpSpread1.ActiveSheetView.SetValue(1, 0, 10);
se = dataModel.GetCustomNameEnumerator();
se.MoveNext();
Response.Write(se.Current.ToString());
|
| Visual Basic | Copy Code |
|---|
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
Dim se As System.Collections.IEnumerator
dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1)
dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2)
FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM")
FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT")
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(1, 0, 10)
se = dataModel.GetCustomNameEnumerator()
se.MoveNext()
Response.Write(se.Current.ToString()) |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
