CSCH Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Compatibility

The named function and the syntax below are in the current, unversioned English ONLYOFFICE Docs Spreadsheet Editor documentation reviewed on 13 October 2026 (UTC). This is documentary support for the current reference, not a successful execution test in ONLYOFFICE Docs/web or Desktop Editors, and it is not a claim of support in all earlier versions, hosting editions, mobile apps, or imported Excel workbooks. The Docs changelog lists version 10.0.0 dated 10 October 2026; that changelog does not identify these particular functions as newly introduced in 10.0. Desktop release history is maintained separately, and no first-supported Desktop/web version has been established for this function.

Verification labels used in this guide: vendor documented = stated in a linked ONLYOFFICE source; independently calculated expectation = calculated outside ONLYOFFICE using mathematics/Python; native result = none obtained. Illustrations/screenshots were not fabricated or substituted for actual tests.

=CSCH(number)

• number (required, numeric): One required numeric argument, documented as a radian-valued angle, with |number| < 2²⁷ in the official ONLYOFFICE reference. No optional arguments and no default.
• Argument order: one positional numeric argument only. Optional arguments/defaults: none.
• Return type: numeric real value for an in-domain mathematical input; the exact cell display can vary with number format.
• Mathematical domain: All real nonzero numeric arguments respecting the vendor |number| < 2²⁷ restriction. Zero is a mathematical singularity.
• Principal range / behaviour: For real nonzero inputs, the mathematical value is nonzero, with the sign of the input. Positive values decay toward zero as the input increases, and negative values approach zero from below as input decreases.
• Units: The official reference describes the argument as an angle in radians; mathematical hyperbolic sine typically takes a dimensionless scalar. Do not confuse this with the circular CSC function, which reciprocates SIN.

Mathematical interpretation: csch(x)=1/sinh(x)=2/(e^x−e^(−x)). It is odd: csch(−x)=−csch(x). Mathematical checks use Python, not ONLYOFFICE execution.

1. Create an empty spreadsheet in the ONLYOFFICE Spreadsheet Editor, using its English formula language for the formulas shown.
2. Enter the numbers exactly as shown in the Input in A column below, beginning in A2 and going down one row per example; do not include the units, symbols, or quotation marks as part of the values.
3. In B2, enter =CSCH(A2), press Enter, and fill the formula down the column. Numeric cells can be formatted to show ten decimal places.
4. Compare your result to the independently calculated expectation, allowing for display rounding and floating-point arithmetic. This guide does not claim that steps 1–3 were executed in either ONLYOFFICE product.

Interpreting the table: values are independent mathematical expectations rounded for readability, not screenshots or verified calculations performed in ONLYOFFICE. Values at very small magnitude may display in scientific notation when the worksheet format changes.

1. Validate against SINH

Set up: Enter D2 = 1, use =CSCH(D2) in E2 and =1/SINH(D2) in F2.

Expected output: Both ≈ 0.8509181282 (independently calculated, not native-tested).

Why it works: The independent reciprocal relationship is the easiest manual cross-check.

2. Verify the odd symmetry

Set up: Enter D3 = 2, =CSCH(-D3) in E3 and =-CSCH(D3) in F3.

Expected output: Both ≈ −0.2757205648 (independently calculated, not native-tested).

Why it works: Changing the sign of the input changes the output sign, preserving magnitude.

3. Safe calculation when the variable can be zero

Set up: Set D4 = 0 and enter =IF(D4=0,"undefined at zero",CSCH(D4)) in E4.

Expected output: The intended text branch: undefined at zero (independently calculated, not native-tested).

Why it works: This makes the worksheet readable for users and avoids relying on an untested application-specific error message.

4. A natural-logarithm identity

Set up: Enter =CSCH(LN(2)) in E5.

Expected output: ≈ 1.3333333333 (4/3) (independently calculated, not native-tested).

Why it works: Because sinh(ln 2)=3/4, its reciprocal is 4/3. This is an independent algebraic fixture.

5. Check the reciprocal product

Set up: Enter =CSCH(2)*SINH(2) in E6.

Expected output: 1 within floating-point precision (independently calculated, not native-tested).

Why it works: The product is mathematically 1 for nonzero finite x; tiny rounding differences may occur.

Error-code caution: ONLYOFFICE documentation for this function does not establish exact error strings for every invalid input, coercion, overflow, or version. Thus this guide does not assert #NUM!, #DIV/0!, or other codes as observed in ONLYOFFICE. Record actual native outputs and version/edition before relying on undocumented error behavior.

The examples use English function names, decimal points and (where needed) comma-separated arguments. The official Insert Function guide explains that manual formulas begin with = and that arguments are separated by commas in its English instructions. The Advanced Settings page documents configurable formula language and regional decimal/thousands separators. Neither source establishes how this exact function was spelled or evaluated for every locale. Do not rewrite formulas using a different locale based only on habits from another spreadsheet program.

The vendor distinguishes the web/Docs editor from Desktop Editors and maintains separate release changelogs. The current function page does not state a first-supported version or guarantee parity across historical installations. Version-sensitive behaviour, real error results, large-value precision, workbook imports, mobile editions, and localized syntax therefore require native verification. A release-note mention of a related Spreadsheet Editor improvement must not be mistaken for a function introduction.

• SINH function — vendor function reference.
• COSH function — vendor function reference.
• COTH function — vendor function reference.
• IF function — vendor function reference.
• LN function — vendor function reference.
• Insert functions in ONLYOFFICE Spreadsheet Editor — function-selection, autocomplete and entry workflow.
• Spreadsheet Editor advanced settings — formula language, regions, and separators.

What is the difference between CSCH and CSC?

CSCH is 1/SINH(x); CSC is 1/SIN(x). Their values generally differ for the same input.

Can CSCH return a negative number?

Yes. For negative nonzero real input its mathematical output is negative.

What happens when x is zero?

The hyperbolic cosecant is undefined at zero; a native app test is required to document the exact error string.

Verification limitations: Native Docs/web and Desktop execution, localized parsing, extreme-value precision, historical editions and runtime error behavior were not tested.