LOCTOLOC function

Microsoft Office ShapeSheet

LOCTOLOC function

See also

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

Syntax

LOCTOLOC(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

The LOCTOLOC function converts a point from local coordinates in a source shape to local coordinates in a destination shape. You can use this function to construct a shape, for example, in terms of a point from another coordinate space. You can also use this function to transform a local point to page coordinates, or vice versa.

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.

Example

LOCTOLOC(PNT(LocPinX, LocPinY), Width, ThePage!PageWidth)

Converts the local pin of the shape associated with the formula to a point on the page.