TdxSpreadSheetContainers Class

A collection of floating containers on a single worksheet.

Declaration

delphi

TdxSpreadSheetContainers = class(
    TObjectList<TdxSpreadSheetContainer>
)

This class extends its ancestor with the following members that allow you to:

Create a new floating container (Add and AddCommentContainer).
Navigate between visible containers (GetFirstVisibleContainer, GetNextVisibleContainer, GetPrevVisibleContainer, and GetLastVisibleContainer).
Search a floating container by its name (FindByName).
Navigate between comment containers (FindNextCommentContainer).
Identify if a cell has an anchored comment container (FindCommentContainer).
Apply the same set of changes to all comment containers in the collection (EnumCommentContainers).
Identify if the specified cell is an anchor cell for one or more floating containers in the collection (IsCellUsed).
Delete a floating container (Clear, Delete and Remove);
Access the worksheet to which the container collection belongs (Owner).

A worksheet’s Containers property references a TdxSpreadSheetContainers object.