LOCTOPAR function

Microsoft Office ShapeSheet

LOCTOPAR function

See also

Returns a transformed point in parent coordinates in the destination coordinate system.

Syntax

LOCTOPAR(srcPoint, srcRef, dstRef)

srcPoint

A point in local coordinates in the source coordinate system.

srcRef

A reference to a cell in the source object.

dstRef

A reference to a cell in the destination object.

Remarks

Converts a point from local coordinates in a source shape to parent coordinates in a destination shape. You can use the LOCTOPAR function to set parent coordinates in cells, such as PinX, PinY, BeginX, and BeginY in a shape using another point from another coordinate system.

This function works even when the source and destination shapes are within groups. It also adjusts for rotation and flips in the intermediate transformation.

The source and destination coordinates must be on the same page.

If the destination is a page, which has no parent, the result is expressed in the page's local coordinates.

Example

LOCTOPAR(PNT(LocPinX, LocPinY), Width, Sheet.4!Width)

Converts the local pin of the shape associated with the formula to parent coordinates of Sheet.4.