RADIANS Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples
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
RADIANScall has no separator to choose; nestedROUND(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
- Create an otherwise empty sheet using the editor’s ordinary grid; no macros, internet data, special add-ins or third-party integrations are needed.
- Enter
Angle inputinA1,RADIANS raw resultinB1, andSix-decimal displayinC1. - 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. - In
B2, enter=RADIANS(A2); inC2, enter=ROUND(B2,6). Fill both downward through row 12 using the Fill handle (or copy/paste, adjusting relative row references). - 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.
- 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.
- ONLYOFFICE: RADIANS official function reference ā direct evidence for the core documented signature/purpose only.
- Excel: Microsoft’s RADIANS 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.
Related links and source review
The links below are official function and editor references, checked on 2026-10-13 UTC.
- Official ONLYOFFICE RADIANS 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.
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.