RADIANS in Collabora Office: Convert Degree Measurements Before Trigonometry
Convert degrees to radians in Collabora Office Calc with angle tables, arc lengths and unit-aware checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: RADIANS converts a degree measurement to radians. =RADIANS(180) is expected to equal approximately PI(). The input is an angle in degrees, not an already-converted radian value.
Availability and version history
- Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
- Availability:
RADIANSis documented in the official 26.04 Calc Help. - Scope: desktop Calc documentation; separately deployed Online and mobile versions have not been verified.
- Checked: October 13, 2026, against the official RADIANS reference. Documentation check; not a native application test. Expected examples are independently calculated.
Syntax and conversion rule
=RADIANS(number)
Collabora’s official reference identifies the input as degrees and the output as radians. The mathematical conversion is degrees multiplied by pi and divided by 180.
The function converts units; it does not automatically reduce an angle to a single revolution or decide its physical direction. A value greater than 360 degrees can validly convert to more than two pi radians.
Example 1: a small angle table
Enter 0, 30, 90, 180, −45 and 360 in A2:A7. Put =RADIANS(A2) in B2 and fill down.
| Degrees | Expected radians to six decimals |
|---|---|
| 0 | 0.000000 |
| 30 | 0.523599 |
| 90 | 1.570796 |
| 180 | 3.141593 |
| -45 | -0.785398 |
| 360 | 6.283185 |
The negative angle retains its sign. A full turn is 360 degrees or two pi radians. The values in the table are rounded displays, not claims of an exact finite decimal expansion of pi.
Keep the original degree values if they are needed for human-readable labels. Storing both units in separate columns makes unit changes visible during an audit.
Example 2: prepare a trigonometric input
For a degree angle of 60 in D2:
=COS(RADIANS(D2))
Expected result: approximately 0.5. The conversion supplies pi/3 radians to the cosine calculation. The Collabora mathematical-function Help separately documents COS as accepting radians.
Passing 60 directly to COS asks for the cosine of 60 radians, which is a different angle. A result may still be a valid number even though the unit was wrong, making this error easy to overlook.
Example 3: calculate an arc length
An ideal circle has radius 10 metres, and an arc subtends 45 degrees at the center. Store the radius in F2 and the degree angle in G2:
=F2*RADIANS(G2)
Expected result: approximately 7.853982 metres. Arc length is radius multiplied by the angle in radians. Multiplying the radius by 45 without conversion would not apply that radian-based formula correctly.
This is an ideal geometric calculation. Radius measurement accuracy, the meaning of a signed angle and whether a major or minor arc is intended must be specified separately.
Advanced example: check a two-way conversion
For an input of 123.4 degrees:
=DEGREES(RADIANS(123.4))
Expected result: approximately 123.4. This checks the relationship between the two conversion functions. A small numerical rounding difference after chained arithmetic is not a change in the intended unit.
Use a justified tolerance for numeric comparisons. Rounding at each intermediate conversion can accumulate avoidable differences, so generally round the final presentation rather than repeatedly replacing stored values.
Example 4: preserve extra revolutions
=RADIANS(450)
Expected result: approximately 7.853982, which is 2.5 times pi. The input is one full revolution plus 90 degrees; the result is not automatically normalized to pi/2.
If a report needs a principal angle within a specified interval, normalization is an additional operation with its own signed-boundary convention. Do not assume conversion and normalization are the same task.
Decimal degrees and imported measurements
A decimal value of 12.5 degrees means twelve and a half degrees. It is not the same notation as twelve degrees and five minutes. Convert degree-minute-second records deliberately before passing a decimal numeric value to RADIANS.
For instance, 12 degrees 30 minutes is 12+30/60, or 12.5 decimal degrees. Its expected radian value is approximately 0.218166. The function does not parse a free-form angle label into those parts automatically.
Troubleshooting and verification
Check the source unit, sign, stored type and whether extra turns should be retained. Label the output column as radians, and do not infer a unit from the number of displayed decimals.
For native verification, record the Collabora build and reproduce the six-row angle table, cosine check, arc calculation and two-way conversion. All answers here were independently calculated; no target-application execution or screenshot is claimed.
Official reference
- Collabora Office 26.04: RADIANS, checked October 13, 2026.
- Editorial standards.