Removes all user-defined names from the model.
Syntax
| Visual Basic (Declaration) | |
|---|
Sub ClearCustomNames() |
| C# | |
|---|
void ClearCustomNames() |
Example
| C# |  Copy Code |
|---|
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();
}
|
| Visual Basic | Copy Code |
|---|
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
