RemoveCustomName Method (SheetView)

In This Topic

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

Reference

SheetView Class
SheetView Members

User-Task Documentation

Creating and Using a Custom Name

Product Support Forum | Print this page