Export (0) Print
Expand All
Expand Minimize

LOCTOLOC Function

Published: July 16, 2012

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

LOCTOLOC(srcPoint, srcRef, dstRef)

Parameters

Name

Required/Optional

Data Type

Description

srcPoint

Required

String

A point in local coordinates in the source coordinate system.

srcRef

Required

String

A reference to a cell in the source object.

dstRef

Required

String

A reference to a cell in the destination object.

Return Value

String

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.

The following formula converts the local pin of the shape associated with the formula to a point on the page.

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

Community Additions

ADD
Show:
© 2014 Microsoft