ClearCustomNames Method (ICustomNameSupport2)

Removes all user-defined names from the model.

Syntax

Visual Basic
C#

'Declaration
 
Sub ClearCustomNames()

'Usage
 
Dim instance As ICustomNameSupport2
 
instance.ClearCustomNames()

void ClearCustomNames()

Example

This example clears the custom names from the model.

FarPoint.Win.Spread.Model.ICustomNameSupport cns; 
cns = (FarPoint.Win.Spread.Model.ICustomNameSupport)fpSpread1.ActiveSheet.Models.Data; 
cns.AddCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20)); 
fpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA");
FarPoint.Win.Spread.Model.ICustomNameSupport2 cns2;
cns2 = (FarPoint.Win.Spread.Model.ICustomNameSupport2)fpSpread1.ActiveSheet.Models.Data;
cns2.ClearCustomNames();
fpSpread1.ActiveSheet.RecalculateAll();

Visual Basic

Dim cns As FarPoint.Win.Spread.Model.ICustomNameSupport
cns = FpSpread1.ActiveSheet.Models.Data
cns.AddCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20))
FpSpread1.ActiveSheet.SetFormula(1, 1, "ALPHA * 2")

Dim cns2 As FarPoint.Win.Spread.Model.ICustomNameSupport2
cns2 = FpSpread1.ActiveSheet.Models.Data
cns2.ClearCustomNames()
FpSpread1.ActiveSheet.RecalculateAll()

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ICustomNameSupport2 Interface
ICustomNameSupport2 Members