DEGREES in Collabora Office: Convert Radian Results into Readable Angles

• Introduced: documented by Collabora Office 26.04; the original introduction release is not established.
• Availability: DEGREES is 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 DEGREES reference. Documentation check; not a native application test. Expected examples are independently calculated.

=DEGREES(number)

The official Collabora reference identifies the argument as an angle in radians. The mathematical conversion multiplies the input by 180/pi.

DEGREES does not discover the original unit automatically. If a cell already contains 90 degrees, passing the value 90 to this function treats it as 90 radians and produces a much larger degree number. Keep units explicit in column labels and formula design.

Enter the following formulas in separate blank cells:

=DEGREES(PI()/2)
=DEGREES(PI())
=DEGREES(-PI()/4)
=DEGREES(2*PI())

Expected results: approximately 90, 180, -45 and 360. The negative angle retains its sign, and a complete turn remains a complete turn.

Use numerical tolerance or a reasonable display precision for chained calculations. Pi cannot be represented by an exact finite decimal string, so the intended geometric relationship is more informative than an arbitrary number of printed digits.

Put the numeric radian value 1.2 in B2:

=DEGREES(B2)

Expected result: approximately 68.754935 degrees to six decimal places. As a magnitude check, 1.2 radians lies below pi/2, so the corresponding positive angle must be less than 90 degrees.

This interval check helps catch unit or decimal-place mistakes. It does not increase the accuracy of the original 1.2-radian measurement; extra output decimals are calculation detail, not added measurement precision.

For an ideal circular arc, the angle in radians is arc length divided by radius. Enter arc length 5 metres in D2 and radius 10 metres in E2:

=DEGREES(D2/E2)

Expected result: approximately 28.647890 degrees. The ratio 5/10 gives 0.5 radians. Arc length and radius must use the same unit before division.

The radius must be positive for this physical model. The calculation does not determine whether a signed arc length, an extra revolution or a particular direction is appropriate; those are assumptions of the measurement process.

A source file supplies 2.4 radians. Convert it to degrees for a report, then convert the numeric degree result back:

=DEGREES(2.4)
=RADIANS(DEGREES(2.4))

Expected results: approximately 137.509871 degrees and 2.4 radians. The second expression checks the inverse relationship without replacing the intermediate value with a rounded text label.

If you first round the degree value to a whole number, the round-trip will no longer recover the original radian value as closely. That difference is caused by the deliberate intermediate rounding, not by a different conversion constant.

=DEGREES(2.5*PI())

Expected result: approximately 450 degrees. The angle contains a full revolution plus a quarter turn. DEGREES does not reduce it automatically to 90 degrees.

A principal-angle display requires a separate normalization policy, including the interval and how negative boundaries are represented. Keeping unnormalized angles may be important when an accumulated rotation count carries information.

Appending a degree symbol to a number can create text, depending on how it is done. Preserve a numeric angle for later formulas and handle the symbol through presentation or a separate text field when appropriate.

Likewise, 68.5 decimal degrees is not a degree-minute pair written as 68 degrees 5 minutes. The decimal fraction 0.5 corresponds to 30 minutes. Do not switch notations merely by adding a symbol or punctuation.

If a result seems much larger than expected, check whether a degree input was mistakenly passed as radians. If a sign is unexpected, trace the source ratio or preceding trigonometric calculation rather than removing the sign indiscriminately.

For native validation, record the application build and compare the four pi-based cases, 1.2 radians, the arc ratio and the round-trip. The answers above are independently calculated expectations. No native Collabora execution or screenshot is claimed.

• Collabora Office 26.04: DEGREES, checked October 13, 2026.
• Editorial standards.