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


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > ICustomNameSupport2 Interface : ClearCustomNames Method
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
See Also

Reference

ICustomNameSupport2 Interface
ICustomNameSupport2 Members