FarPoint.Win.Spread
RemoveCustomName Method
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : RemoveCustomName Method


name
Custom name to remove
Removes a custom name on this sheet from the model.

Syntax

Visual Basic (Declaration) 
Public Sub RemoveCustomName( _
   ByVal name As String _
)
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim name As String
 
instance.RemoveCustomName(name)
C# 
public void RemoveCustomName( 
   string name
)

Parameters

name
Custom name to remove

Example

This example removes a custom name from the sheet.
C#Copy Code
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 BasicCopy Code
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

See Also