TdxSpreadSheetContainer Class

The base class for all classes that implement floating containers.

Declaration

TdxSpreadSheetContainer = class(
    TdxSpreadSheetPersistentObject
)

Remarks

This class implements the functionality common to the shape, picture, text box, and comment containers.

The TdxSpreadSheetContainer class has the following members that allow you to:

Switch between container anchor modes (AnchorType).
Determine the floating container’s position and size (AnchorPoint1 and AnchorPoint2).
Set the optional title and alternative text description for screen readers (Title and Description).
Focus the container (Focused).
Obtain the container’s index in a container collection (Index).
Set the container as a hyperlink‘s hot area (Hyperlink).
Improve a spreadsheet-based application’s performance in the case of multiple changes that affect the container’s appearance (BeginUpdate and EndUpdate).
Record a set of changes to the container as a history action (BeginChanging and EndChanging).
Restrict end-user interactions with the container (Restrictions).
Change the container’s z-order (BringToFront and SendToBack).
Assign a meaningful name to the container (Name).
Hide the floating container (Visible).
Flip and rotate the container (Transform).
Move the floating container between worksheets (Parent).

Do not use the TdxSpreadSheetContainer class directly. Use its descendants instead.

Call a worksheet’s Containers.Add method and pass a reference to a required container class to create the corresponding container.

A worksheet’s Containers.Items property provides indexed access to individual floating containers. To expose a container’s type-specific members, cast a container to the corresponding TdxSpreadSheetContainer class descendant.