RemoveCustomName Method (SheetView)

Removes a custom name on this sheet from the model.

Overload List

Overload	Description
RemoveCustomName(String,Boolean)	Removes a custom name on this sheet from the model.
RemoveCustomName(String)	Removes a custom name on this sheet from the model.

Example

This example removes a custom name from the sheet.

DialogResult dlg;
fpSpread1.ActiveSheet.SetValue(0, 0, 20);
fpSpread1.ActiveSheet.SetValue(1, 0, 100);
fpSpread1.ActiveSheet.AddCustomName("Alpha", "Sum(A1,A2)", 1, 1);
fpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha");
dlg = MessageBox.Show("Do you want to remove the custom name?", "RemoveCustomName", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
    fpSpread1.ActiveSheet.RemoveCustomName("Alpha");
    fpSpread1.ActiveSheet.RecalculateAll();
}

Visual Basic

Dim dlg As DialogResult
FpSpread1.ActiveSheet.SetValue(0, 0, 20)
FpSpread1.ActiveSheet.SetValue(1, 0, 100)
FpSpread1.ActiveSheet.AddCustomName("Alpha", "Sum(A1,A2)", 1, 1)
FpSpread1.ActiveSheet.SetFormula(1, 1, "Alpha")
dlg = MessageBox.Show("Do you want to remove the custom name?", "RemoveCustomName", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
    FpSpread1.ActiveSheet.RemoveCustomName("Alpha")
    FpSpread1.ActiveSheet.RecalculateAll()
End If

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

SheetView Class
SheetView Members
AddCustomFunction Method

User-Task Documentation

Creating and Using a Custom Name