Skip to main content

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.

VCL Spreadsheet: The "Create Names from Selection" Dialog

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.

Inheritance

See Also