TdxSpreadSheetDefinedNameEditDialogForm Class

The form class that implements the “New Name” and “Edit Name” dialogs in spreadsheet controls.

Declaration

TdxSpreadSheetDefinedNameEditDialogForm = class(
    TdxSpreadSheetReferenceEditDialogForm
)

Remarks

The “New Name” and “Edit Name” dialogs complement the “Name Manager“ dialog’s functionality. Both dialogs have the Name, Comment, and Reference fields to set up the corresponding defined name settings. Note that the Scope combo box is enabled only in “New Name”.

Like in “Name Manager”, you can click the button at the right editor’s border to collapse the “New Name” or “Edit Name” dialog to track reference changes in the target worksheet or drag the highlighted cell outline to change the reference.

A click on the “New…” button in the “Name Manager” dialog and the CreateDefinedName end-user command call the ShowDefinedNameEditDialog procedure to invoke the “New Name” dialog. To invoke the “Edit Name” dialog, you can either click the “Edit…” button in the “Name Manager” dialog or pass the target defined name as the optional ADefinedName parameter of the ShowDefinedNameEditDialog procedure.

If you need to adjust or customize UI elements in the “New Name” and “Edit Name” dialogs, derive a custom form from the TdxSpreadSheetDefinedNameEditDialogForm class. Assign a reference to the SpreadSheetDefinedNameEditDialogFormClass global variable to replace both standard dialogs available in spreadsheet controls.