FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : GetCustomNameEnumerator Method |
'Declaration Public Function GetCustomNameEnumerator() As IEnumerator
'Usage Dim instance As DefaultSheetDataModel Dim value As IEnumerator value = instance.GetCustomNameEnumerator()
public IEnumerator GetCustomNameEnumerator()
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())
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