TdxSpreadSheetDefinedNameManagerDialogForm Class
The form class that implements the Name Manager dialog in spreadsheet controls.
Declaration
TdxSpreadSheetDefinedNameManagerDialogForm = class(
TdxSpreadSheetReferenceEditDialogForm,
IdxSpreadSheetListener2
)Remarks
This dialog lists all defined names in a spreadsheet document, except for print-related defined names, and includes UI elements for defined name management.
A click on the New… button hides the Name Manager dialog and invokes the New Name dialog. The Name Manager dialog reappears once a user closes New Name.
If an existing defined name is selected, the Edit… and Delete buttons are available. A click on the Edit… button invokes the Edit Name dialog that allows a user to customize the selected defined name. As with New Name, the Name Manager dialog is hidden while the Edit Name dialog is visible.
An editor at the bottom of the Name Manager dialog allows users to adjust the target reference of the selected defined name. You can click the button at the right editor’s border to collapse the dialog to track reference changes in the target worksheet or drag the highlighted cell outline to change the reference.
The Ctrl+F3 keystroke and the ShowDefinedNameManager end-user command call the ShowDefinedNameManagerDialog global procedure to invoke the Name Manager dialog.
If you need to adjust or customize UI elements in the “Name Manager” dialog, derive a custom form from the TdxSpreadSheetDefinedNameManagerDialogForm class. Assign a reference to the SpreadSheetDefinedNameManagerDialogFormClass global variable to replace the standard dialog available in spreadsheet controls.
Note
If the active worksheet is protected, the Name Manager dialog displays the list of defined names in read-only mode.