DEGREES Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=DEGREES(PI()) corresponds to 180 degrees; this is an independently calculated expected result using ONLYOFFICE’s documented PI() constant.

Verification: All numerical outputs are independently calculated mathematical expectations, not observations from native ONLYOFFICE execution.

Radian angles are convenient in calculations but degree values are often easier to communicate. DEGREES converts a numeric radian angle into degrees by the mathematical relationship degrees = radians × 180 / π. ONLYOFFICE’s dedicated DEGREES help article documents that direction and the one required numeric argument. Conversion neither changes the geometric angle nor automatically reduces it into a range such as 0°–360°.

Common reasons to use it: conversion of radian sensor or rotation values to human-readable angles. When a rotation sensor provides radians, report =DEGREES(value_cell); when a report provides degrees for a trigonometric model, use RADIANS instead.

=DEGREES(angle)

The vendor explicitly identifies radian input and shows DEGREES(angle). The formula does not accept a second input, and the single argument has no default. The returned value is expressed in degrees. The argument spelling and order are taken from the official ONLYOFFICE DEGREES reference, accessed 2026-10-13 (UTC). The help page is unversioned: syntax documentation does not establish which Desktop/Web builds first implemented the function or the outcome for all data types.

• Current documented surface: The ONLYOFFICE Spreadsheet Editor function catalogue lists DEGREES under math/trigonometry, and the function-specific page confirms its syntax. Accessed 2026-10-13 UTC. It is an English Docs help catalogue, not a cross-platform execution matrix.
• Separate releases: ONLYOFFICE maintains Docs release notes and Desktop Editors release notes. A Docs 10.0 announcement dated 10 October 2026 does not prove this function first appeared in 10.0, nor does it establish identical behaviour in every self-hosted or desktop release. First-supported version and all release-specific details are unverified.
• Editor selection: The official insertion instructions describe Home or Formula → Insert Function and the Shift+F3 shortcut. You may also type formulas beginning with = into a cell.
• Language: Advanced Settings → Regional settings documents a Formula Language setting, so localized names can differ. This page uses English function names. Localized formula names should be checked in the target editor.
• Separators and display: The same official settings page documents regional decimal/thousands separators. The ONE-argument DEGREES call has no separator to choose; nested ROUND(number,num_digits) examples below use a comma in English formula notation. The docs consulted do not exhaustively specify argument separators for every locale or deployment. If an imported formula will not parse, inspect the editor’s formula language and locale, rather than assuming all environments use the same punctuation.
• App test status: No ONLYOFFICE Desktop, web, mobile, or self-hosted installation was executed. Results are independent calculations and official documentation checks, not native validation.

1. Create an otherwise empty sheet using the editor’s ordinary grid; no macros, internet data, special add-ins or third-party integrations are needed.
2. Enter Angle input in A1, DEGREES raw result in B1, and Six-decimal display in C1.
3. Enter exactly the inputs shown in column A below. Entries beginning with = are formulas; other entries are numeric constants. Do not type the backtick formatting characters.
4. In B2, enter =DEGREES(A2); in C2, enter =ROUND(B2,6). Fill both downward through row 12 using the Fill handle (or copy/paste, adjusting relative row references).
5. Compare column C against the independent expected six-decimal values. Raw values in column B may display more or fewer digits depending on cell number formatting.
6. If a result differs, check the input unit, Formula Language, number formatting and editor release before reporting a defect.

Calculation basis: radians × 180 ÷ π, then rounding the mathematical result for display at six digits. The table does not suggest that every binary floating-point implementation stores exactly the same 64-bit value.

The expressions below can each be entered into a fresh empty cell. They demonstrate transformations and realistic combinations with already documented functions; their results were independently calculated, not observed in a running ONLYOFFICE editor.

Suppose an arc is 12 metres long on a circle of radius 20 metres. Because θ (radians) = arc length/radius, enter E2=12, F2=20, then =ROUND(DEGREES(E2/F2),6). The independently calculated angle is 34.377468°. If units for length and radius differ, convert them first: a ratio of centimetres to metres is not directly a radian angle.

Independent cross-check: The inverse mathematical check =DEGREES(RADIANS(45)) should be about 45°, not an exact binary guarantee. Keeping a PI() expression typically avoids the loss of precision from hand-typed approximations like 1.57. For a maintained workbook, store the original input unit and the converted result in separate labelled columns. That makes a later discrepancy traceable, especially when combining imported angles with geometric measurements.

The formula’s input is radians, not degrees. π radians is 180°, 2π radians is a complete turn and a negative radian angle maps to a negative degree angle. The published reference does not specify text coercion, empty-cell behavior or exact error codes. The source does not exhaustively document missing arguments, text-to-number coercion, overflow, or exact vendor-specific error codes. The remedies below are engineering guidance; no special cases have been presented as if they were natively tested.

Precision note: A cell format showing 0.000000 controls display, not the underlying numerical model. Use ROUND(...,6) when the six-digit value itself is what you wish to calculate with. Rounding early can accumulate error in later calculations; do not interpret a six-decimal expectation as six-decimal native storage. Formula and arithmetic errors depend on input type and release and should be verified on the target version before relying on an error-code chart.

Excel’s DEGREES reference describes the same radian-to-degree conversion. LibreOffice’s mathematical functions documentation also covers degree/radian conversions. The conceptual formulas can travel between products, but this does not verify ONLYOFFICE vs Excel vs LibreOffice coercion, formatting, or numerical rounding. Formula separators and localized function names may also differ by configuration.

• ONLYOFFICE: DEGREES official function reference — direct evidence for the core documented signature/purpose only.
• Excel: Microsoft’s DEGREES function documentation — evidence of the corresponding Excel mathematical contract, not a ONLYOFFICE behavioural test.
• LibreOffice Calc: Mathematical Functions official manual — separate Calc vendor documentation; confirm localized names and separators if you exchange workbooks.

Compatibility status: The English single-argument expression is documented in ONLYOFFICE; the common mathematical idea is cross-vendor documented, but cross-application numeric/error interoperability and historical-version support remain pending native validation.

The links below are official function and editor references, checked on 2026-10-13 UTC.

• Official ONLYOFFICE DEGREES function — argument order and stated purpose.
• ONLYOFFICE PI function — PI() is a documented zero-argument π constant, used by the examples.
• ONLYOFFICE ROUND function — ROUND(number,num_digits) rounds a number to a specified precision.
• ONLYOFFICE RADIANS function — conversion from degrees to radians.
• ONLYOFFICE DEGREES function — conversion from radians to degrees.
• ONLYOFFICE SIN function — sine of an angle.
• ONLYOFFICE Function insertion/catalogue and Advanced settings — app workflow and locale context.

Documentation was checked on 2026-10-13. The unversioned references establish documented syntax, not historical availability. No native editor, localized parsing, runtime error or workbook interchange testing was performed.

Original instructional content prepared for Spreadsheet-Tutorials.com; not an endorsement from or partnership with ONLYOFFICE.