Spread for ASP.NET 8.0 Product Documentation
ClearCustomNames Method (ICustomNameSupport2)
Example 


Removes all user-defined names from the model.
Syntax
'Declaration
 
Sub ClearCustomNames() 
'Usage
 
Dim instance As ICustomNameSupport2
 
instance.ClearCustomNames()
void ClearCustomNames()
Example
FarPoint.Web.Spread.Model.ICustomNameSupport cns; 
cns = (FarPoint.Web.Spread.Model.ICustomNameSupport)FpSpread1.ActiveSheetView.DataModel; 
cns.AddCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20)); 
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA * 20");

private void Button1Click(object sender, System.EventArgs e)
{
    FarPoint.Web.Spread.Model.ICustomNameSupport2 cns2; 
    cns2 = (FarPoint.Web.Spread.Model.ICustomNameSupport2)FpSpread1.ActiveSheetView.DataModel; 
    cns2.ClearCustomNames();
    FpSpread1.ActiveSheetView.Recalculate();
}
Dim cns As FarPoint.Web.Spread.Model.ICustomNameSupport
cns = FpSpread1.ActiveSheetView.DataModel
cns.AddCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20))
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA * 20")

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim cns2 As FarPoint.Web.Spread.Model.ICustomNameSupport2
    cns2 = FpSpread1.ActiveSheetView.DataModel
    cns2.ClearCustomNames()
    FpSpread1.ActiveSheetView.Recalculate()
End Sub
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

ICustomNameSupport2 Interface
ICustomNameSupport2 Members

 

 


Copyright © GrapeCity, inc. All rights reserved.