TdxSpreadSheetCreateDefinedNamesFromSelectionDialogForm Class

The form class that implements the “Create Names from Selection” dialog in spreadsheet controls.

Declaration

TdxSpreadSheetCreateDefinedNamesFromSelectionDialogForm = class(
    TdxForm
)

Remarks

This dialog allows users to interpret certain cell values as defined name captions and create multiple defined names from one or more selected cell ranges. The available four checkboxes correspond to cells located at the corresponding borders within a selected cell range. If it is impossible to interpret one of these cell values as valid defined name identifiers, the “Create Names from Selection” dialog does not create the corresponding defined name.

An Enter keystroke or OK button click calls a spreadsheet control’s DefinedNames.AddFromSelection procedure to create defined names from the current cell selection according to the selected defined name captions.

The CreateDefinedNamesFromSelection end-user command calls the ShowCreateDefinedNamesFromSelectionDialog global procedure to invoke the “Create Names from Selection” dialog for the active worksheet.

If you need to adjust or customize UI elements in the “Create Names from Selection” dialog, derive a custom form from the TdxSpreadSheetCreateDefinedNamesFromSelectionDialogForm class. Assign a reference to the dxSpreadSheetCreateDefinedNamesFromSelectionDialogFormClass global variable to replace the standard dialog available in spreadsheet controls.