Skip to main content

TdxSpreadSheetContainerAnchorPoint.Offset Property

Specifies the absolute horizontal and/or vertical offset values (in pixels) from the base position of the container anchor point within a worksheet.

Declaration

property Offset: TPoint read; write;

Property Value

Type
TPoint

Remarks

Unlike the Cell and FixedToCell property values, this property is in effect regardless of the floating container object‘s AnchorType property value. The latter, however, affects the Offset property value interpretation by the Spreadsheet control:

The AnchorType Value

Description

Example

catAbsolute

For the upper-left anchor point, the Offset property specifies the absolute position (in pixels by horizontal and vertical axes, starting from the upper-left worksheet corner) of the container anchor point.

For the bottom-right anchor point, the Offset property specifies the absolute offsets by horizontal and vertical axes (in pixels) from the upper-left anchor point‘s position. These offsets by horizontal and vertical axes correspond to the floating container object’s absolute width and height, respectively.

catOneCell

For the upper-left anchor point, the Offset property specifies the absolute offsets by horizontal and vertical axes (in pixels) from the base position (in the upper-left corner of the anchoring cell).

For the bottom-right anchor point, the Offset property specifies the absolute offsets by horizontal and vertical axes (in pixels) from the upper-left anchor point‘s position. These offsets by horizontal and vertical axes correspond to the floating container object’s absolute width and height, respectively.

catTwoCell

For both the upper-left and bottom-right anchor points, the Offset property specifies the absolute offsets (in pixels by horizontal and vertical axes) from their base positions (in the upper-left corner of the respective anchor cells).

See Also