DefinedNameConflictResolvingEventArgs.UseExistingName Property

Gets or sets a value indicating whether to use the defined name specified on the destination worksheet or workbook in the conflict situation.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public bool UseExistingName { get; set; }

VB.NET

Public Property UseExistingName As Boolean

Property Value

Type	Description
Boolean	true, to use the name that exists on the destination worksheet or workbook; otherwise, false.

Remarks

The following example demonstrates how to handle the UseExistingName event to always use that version of the defined name that exists on the destination worksheet or workbook in a conflict situation and suppress displaying the Name Conflict dialog.

C#

spreadsheet.DefinedNameConflictResolving += spreadsheet_DefinedNameConflictResolving;
// ...

private void spreadsheet_DefinedNameConflictResolving(object sender, DefinedNameConflictResolvingEventArgs e)
{
    e.UseExistingName = true;
    e.Handled = true;
}

VB.NET

AddHandler spreadsheet.DefinedNameConflictResolving, AddressOf spreadsheet_DefinedNameConflictResolving
' ...

Private Sub spreadsheet_DefinedNameConflictResolving(ByVal sender As Object, ByVal e As DefinedNameConflictResolvingEventArgs)
    e.UseExistingName = True
    e.Handled = True
End Sub