TdxSpreadSheetMergedCellList Class

A merged cell collection in a Table View worksheet.

Declaration

TdxSpreadSheetMergedCellList = class(
    TcxDoublyLinkedObjectList
)

This class a public API for the merged cells functionality in spreadsheet controls.

The TdxSpreadSheetMergedCellList class provides the following members that allow you to:

Obtain the number of merged cells in a worksheet (Count).
Access the worksheet to which the merged cells belong (View).
Access individual merged cells (First, Items, and Last).
Manage the merge cell collection (Add, Delete, and Clear).
Populate a list with pointers to all merged cells within a designated area (Extract).
Obtain the area of a cell or merged cell at the specified location in a worksheet (CheckCell).
Attempt to obtain a merged cell at the specified location in a worksheet (FindCell).
Identify if there are any merged cells within a designated area and unmerge them (HasItemsInArea and DeleteItemsInArea).
Expand one or more merged cells in the collection (ExpandArea).

A Table View worksheet’s MergedCells property references a TdxSpreadSheetMergedCellList object.

TdxSpreadSheetMergedCellList