Contact

RADIANS Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

Math and Trigonometry Beginner ONLYOFFICE Spreadsheet Editor

Convert degrees to radians for trigonometry, arc length, rotation and engineering formulas with independently checked examples.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Availability and version history

  • Introduced: The original introduction version and date are not established by the official sources checked.
  • Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
  • Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
  • Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

Quick answer

=RADIANS(180) represents a half-turn in radians: its independently calculated expected value is approximately 3.141592653589793, or 3.141593 to six decimal places.

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

What the function does

Angles measured in degrees are common in diagrams and measurements, but mathematical trigonometry typically uses radians. RADIANS converts a numeric degree angle into the corresponding radian angle, using the mathematical relationship radians = degrees Ɨ Ļ€ / 180. The official ONLYOFFICE function reference explicitly confirms the direction of conversion and the single argument. This is a numerical unit conversion; it does not round or constrain angles to a single turn.

Common reasons to use it: degree-based engineering models, circular arc computations and trigonometric formulas. Check the unit whenever you copy a formula from geometry into trigonometry: a degree input such as 30 usually must become RADIANS(30) before passing it to a sine expression.

Exact official syntax and arguments

=RADIANS(angle)
Argument Required Type and unit Purpose Documented default
angle Yes (sole positional argument) Numeric value or formula/cell reference representing degrees Convert degrees to radians None: no optional argument documented

The vendor describes degree input; it does not offer an optional second argument. Use =RADIANS(A2) for a cell reference, or =RADIANS(90) for a literal value. The returned value is expressed in radians. The argument spelling and order are taken from the official ONLYOFFICE RADIANS 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.

Version, platform and localization boundaries

  • Current documented surface: The ONLYOFFICE Spreadsheet Editor function catalogue lists RADIANS 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 RADIANS 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.

Make the reproducible example worksheet

  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, RADIANS 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 =RADIANS(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.
Row Type into A Formula in B Formula in C Independently expected C value
2 0 =RADIANS(A2) =ROUND(B2,6) 0
3 30 =RADIANS(A3) =ROUND(B3,6) 0.523599
4 45 =RADIANS(A4) =ROUND(B4,6) 0.785398
5 90 =RADIANS(A5) =ROUND(B5,6) 1.570796
6 180 =RADIANS(A6) =ROUND(B6,6) 3.141593
7 270 =RADIANS(A7) =ROUND(B7,6) 4.712389
8 360 =RADIANS(A8) =ROUND(B8,6) 6.283185
9 -30 =RADIANS(A9) =ROUND(B9,6) -0.523599
10 720 =RADIANS(A10) =ROUND(B10,6) 12.566371
11 22.5 =RADIANS(A11) =ROUND(B11,6) 0.392699
12 1 =RADIANS(A12) =ROUND(B12,6) 0.017453

Calculation basis: degrees Ɨ Ļ€ Ć· 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.

More worked examples

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.

Situation Formula to enter Independently expected display Why it works
Half turn =ROUND(RADIANS(180),6) 3.141593 180° equals Ļ€ radians in exact mathematics.
Arc length, radius 15 and central angle 32° =ROUND(15*RADIANS(32),6) 8.37758 Apply s = rθ with θ in radians; the unit of s matches the radius.
One arcminute =ROUND(RADIANS(1/60),9) 0.000290888 One arcminute is one sixtieth of a degree; display nine decimal places.
Equivalent formula, 75° =ROUND(75*PI()/180,6) 1.308997 Independent equivalence check using the documented PI function.
Turn measured by sine =ROUND(SIN(RADIANS(30)),6) 0.5 Nested function is a cross-check, not an observed app output.

Advanced use: a model, not just a lookup

For a circular path, arc length is radius Ɨ angular measure in radians. Set E2=15 for radius, F2=32 for central degrees, then calculate =ROUND(E2*RADIANS(F2),6) (independently expected 8.37758). If your radius is in metres, the arc length is in metres. The conversion belongs inside the arc-length expression, not after multiplication by a degree angle.

Independent cross-check: The inverse mathematical check =DEGREES(RADIANS(45)) is expected near 45, subject to floating-point tolerance. Passing 45 directly to DEGREES instead has a different meaning. 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.

Practical limits, errors and troubleshooting

Positive, zero, negative and angles larger than one revolution are all legitimate mathematical degree values. The official reference does not enumerate every special numeric edge case or exactly how it coerces text cells; those details remain native-test items. 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.

Symptom / misconception What is happening Practical check
Accidentally entering radians =RADIANS(PI()/2) treats approximately 1.5708 as degrees, not as radians; the result is approximately 0.027416 radians. Check the input unit, not simply whether the formula has a number.
Confusing a conversion with normalization =RADIANS(720) is approximately 12.566371 rather than zero. A 720° input represents two turns; use a separate normalization step only if your application requires one.
Expecting a rounded degree-to-radian result The raw output can show a long decimal expansion depending on the display format. Use cell number formatting or ROUND(...,6) only when the precision limit is intentional.
Unsupported/error-like input Text values, blank references, formula omissions, and very large magnitudes are not exhaustively specified by the vendor RADIANS article. Verify the particular input and editor build; do not assume an Excel-specific error code.

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.

Comparison: ONLYOFFICE, Excel and LibreOffice Calc

Microsoft Excel independently documents RADIANS(angle) as degrees-to-radians, and LibreOffice Calc describes the same conceptual conversion. Their references corroborate interchangeable mathematical intent, not byte-identical floating-point results, locale parsing or error handling in ONLYOFFICE. RADIANS and DEGREES are inverse mathematically within floating-point tolerance; do not demand bitwise equality.

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.

Evidence, release scope and validation disclosure

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.