TdxSpreadSheetMergeCells Class

An action object that corresponds to the MergeCells command provided by the Spreadsheet and Report Designer controls.

Declaration

TdxSpreadSheetMergeCells = class(
    TdxSpreadSheetAction
)

This class does not introduce any new public members. Executing this action object merges all currently selected cell ranges into individual cells that occupy the same areas.

VCL SpreadSheet: A Merge Cells Operation Example

Technically, the TdxSpreadSheetMergeCells action objects call the MergeSelected procedure for the active Table View worksheet.

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

Spreadsheet document editing is allowed (i.e., the control’s OptionsBehavior.Editing property is set to True).
The active worksheet is not protected (i.e., its Options.Protected and/or OptionsProtection.Protected properties are set to False).

To split a merged cell, an end-user should select it and execute a TdxSpreadSheetUnmergeCells action object.