Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetMergedCellList Class

A merged cell collection in a Table View worksheet.

#Declaration

Delphi
TdxSpreadSheetMergedCellList = class(
    TcxDoublyLinkedObjectList
)

#Remarks

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.

#Inheritance

TObject
TcxDoublyLinkedObjectList
TdxSpreadSheetMergedCellList
See Also