GRAVITY Function
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.