Edit

GRAVITY Function

  • Article

Calculates a text block's correct angle of rotation for the indicated shape rotation to prevent the text from turning upside down.

Syntax

GRAVITY(angle,[ limit1 ],[ limit2 ])

Parameters

Name Required/Optional Data Type Description
angle
Required
String
The shape's angle.
limit1
Optional
String
First limit of rotation. Default is 90 degrees.
limit2
Optional
String
Second limit of rotation. Default is 270 degrees.

Return value

String

Remarks

The GRAVITY function is usually used in the TxtAngle cell.

The value returned is 180 degrees if angle is between the values specified by limit1 and limit2; otherwise the value returned is 0 degrees.

All of the arguments are automatically normalized between 0 and 360 degrees by the function. If an argument does not specify units, radians are assumed.

Example 1

GRAVITY(Angle)

Returns 180 degrees if angle is between 90 and 270 degrees; otherwise, returns 0 degrees.

Example 2

GRAVITY(2)

Returns 180 degrees, because 2 radians is between 90 and 270 degrees.

Example 3

GRAVITY(100 deg, 110 deg, 290 deg)

Returns 0 degrees.

Example 4

GRAVITY(100 deg, 290 deg, 110 deg)

Returns 0 degrees.