TdxSpreadSheetContainer.AnchorPoint1 Property

Stores settings of the floating container’s upper-left anchor point.

Declaration

property AnchorPoint1: TdxSpreadSheetContainerAnchorPoint read; write;

Property Value

Type
TdxSpreadSheetContainerAnchorPoint

Remarks

The AnchorPoint1 and AnchorPoint2 properties determine the position (i.e., the point of origin) and size of the floating container within a worksheet. The AnchorPoint1 property corresponds to the anchor point at the upper-left corner of the container’s bounding rectangle, while the AnchorPoint2 property corresponds to the anchor point at the bottom-right corner of the container’s bounding rectangle:

The AnchorPoint1 property provides access to the following properties that allow you to:

• Assign the anchor cell, i.e., the cell object to which the container’s upper-left corner is anchored (AnchorPoint1.Cell);

• Determine the container’s behavior when the anchor cell moves as a result of resizing the column and/or row (AnchorPoint1.FixedToCell);

• Depending on the AnchorType property value, specify either the absolute anchor point position (in pixels) from the top and left worksheet borders or the absolute offset (in pixels) from the upper-left corner of the anchor cell (AnchorPoint1.Offset).

Both the applicability and behavior of particular settings provided by the AnchorPoint1 property depend on the AnchorType property value. For additional information about floating container anchoring, refer to the Anchoring Settings topic.

Note

If called, the worksheet’s Containers.AddCommentContainer method automatically assigns valid settings to both the AnchorPoint1 and AnchorPoint2 property sets for the newly created floating comment container.