Spread for ASP.NET 8.0 Product Documentation
GetCustomNameEnumerator Method (DefaultSheetDataModel)
Example 


Gets an IEnumerator that enumerates through the names of the named expressions in the model.
Syntax
'Declaration
 
Public Function GetCustomNameEnumerator() As IEnumerator
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As IEnumerator
 
value = instance.GetCustomNameEnumerator()
public IEnumerator GetCustomNameEnumerator()

Return Value

IEnumerator setting for the custom name
Example
This example returns a custom name from the model.
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());
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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.