Back to Devexpress

DefinedNameCollection.Remove(String) Method

officefileapi-devexpress-dot-spreadsheet-dot-definednamecollection-dot-remove-x28-system-dot-string-x29.md

latest2.7 KB
Original Source

DefinedNameCollection.Remove(String) Method

Removes the defined name with the specified name from the collection.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void Remove(
    string name
)
vb
Sub Remove(
    name As String
)

Parameters

NameTypeDescription
nameString

A String value that specifies the name (DefinedName.Name) of the defined name to be removed from the collection.

|

Remarks

Note that calling the Remove method also disposes all elements removed from the collection.

To remove a defined name specified by its index in the collection, use the DefinedNameCollection.RemoveAt method. To remove all defined names from the collection, use the DefinedNameCollection.Clear method.

Note

After you delete a defined name, all cells using that name will display the #NAME? error. After you delete a named cell or cell range, all cells using defined names that refer to the deleted cell or cell range will display the #REF! error.

To add a new defined name to the collection, use the DefinedNameCollection.Add method.

See Also

Defined Names

DefinedNameCollection Interface

DefinedNameCollection Members

DevExpress.Spreadsheet Namespace