SIN Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=SIN(PI()/2) has an independently calculated expected value of 1. For degree input, =SIN(RADIANS(30)) has expected value about 0.5 rather than treating 30 as 30 radians.

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

Sine relates an angle to a vertical coordinate on the unit circle, producing a dimensionless result between −1 and +1 in exact real-number mathematics. The ONLYOFFICE SIN article specifically documents SIN(number) as the sine of a numeric angle but its short prose does not explicitly state the unit; the radian-unit convention below is based on standard trigonometry, the official ONLYOFFICE RADIANS converter, and independent interoperability documentation. A native ONLYOFFICE build must still be tested for version-specific edge cases and input parsing.

Common reasons to use it: right-triangle measurements, repeating waves, circular-motion components and phase models. For a degree-based drawing, combine RADIANS and SIN in a single formula, for example =12*SIN(RADIANS(30)) to estimate vertical position 6 on a radius or arm of length 12.

=SIN(number)

The vendor help page calls number the numeric quantity whose sine is returned, without a separately documented default. Standard trigonometric formulas use radians; the official ONLYOFFICE RADIANS converter and Excel/LibreOffice documentation support the degree-conversion workflow. The ONLYOFFICE SIN article itself does not spell out “radians” in its short argument description. The returned value is expressed in sine (dimensionless, -1 to +1 mathematically). The argument spelling and order are taken from the official ONLYOFFICE SIN 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 SIN 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 SIN 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, SIN 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 =SIN(A2); in C2, enter =ROUND(B2,6). Fill both downward through row 13 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: standard mathematical sine of radian input, 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.

A right-triangle arm of length 12 at elevation 30° has vertical component 12×sin(30°)=6 by mathematical calculation. Enter E2=12 (length) and F2=30 (degrees), then =ROUND(E2*SIN(RADIANS(F2)),6) (independently expected 6). For a simple periodic measurement with centre 5 and amplitude 2, =ROUND(5+2*SIN(RADIANS(90)),6) has expected value 7. These are geometry examples, not readings from a sensor or ONLYOFFICE runtime test.

Independent cross-check: In exact mathematics sin(π)=0. In floating-point calculation a very small residual is possible, so comparing the raw result to zero exactly can be misleading. =ROUND(SIN(PI()),6) has independently expected result 0 to six decimal places. Preserve raw values when modelling, and round only at a deliberate reporting boundary. 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.

A sine wave cycles every 2π radians, accepts negative angles mathematically, and can produce very small floating-point residuals where exact mathematics says zero. This does not establish the exact decimal result of a particular ONLYOFFICE release or justify using exact equality comparisons on unrounded sine outputs. 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 SIN documentation specifies a radian angle and explicitly recommends RADIANS for degree inputs; LibreOffice Calc’s SIN documentation likewise specifies radians. ONLYOFFICE’s help explicitly documents the sine result and numeric signature, but does not restate units, so precise parity with Excel/LibreOffice has not been natively verified. Mathematical expectations here are not evidence that all products produce identical binary values or errors.

• ONLYOFFICE: SIN official function reference — direct evidence for the core documented signature/purpose only.
• Excel: Microsoft’s SIN 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 SIN 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.