Skip to main content

TdxSpreadSheetCreateDefinedNamesFromSelection Class

Implements the CreateDefinedNamesFromSelection end-user command available for spreadsheet controls.

Declaration

TdxSpreadSheetCreateDefinedNamesFromSelection = class(
    TdxSpreadSheetAction
)

Remarks

This class does not introduce any new public members. Its overridden Execute function invokes the Create Names from Selection dialog where an end user can specify the sources of defined name identities at selection area borders.

"Create Names from Selection" Dialog Example

If the selection area has no cells with values that can be valid defined name identifiers, the “Create Names from Selection” dialog does not create any defined names.

UI elements linked to a TdxSpreadSheetCreateDefinedNamesFromSelection action object are enabled only if the following conditions are met:

  • Spreadsheet document edit operations are allowed (that is, the control’s OptionsBehavior.Editing property is set to True).

  • An in-place cell editor is inactive (the active worksheet’s IsEditing property returns False).

  • The active worksheet is not protected (that is, its OptionsProtection.Protected property is set to False).

To localize the caption of UI elements linked to a TdxSpreadSheetCreateDefinedNamesFromSelection action object, use the sdxSpreadSheetActionCreateDefinedNamesFromSelectionCaption resource string.

See Also