CSCH Function (OpenOffice Calc)

• Introduced: First release not established; presence is verified in Apache OpenOffice 4.1.16. Earlier support has not been established here.
• Supported in: Apache OpenOffice 4.1.16; this identifies a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight reference formulas and the listed diagnostics were recalculated from generated native ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent reference calculations were also checked.

CSCH calculates hyperbolic cosecant, mathematically 1/sinh(x). It returns a real numeric value for a valid finite input where the defining denominator is nonzero. The implementation evaluates the reciprocal directly, so denominator zeros and floating-point behavior matter. Release entry.

=CSCH(Number)

Supply one numeric argument. The argument is a real, dimensionless input; this hyperbolic function has no intrinsic degree unit. The observed TRUE argument becomes 1, and a referenced empty cell becomes 0. Non-numeric text and an extra argument produce errors in the tested cases.

The native column records the saved 4.1.16 results. The independent values use high-precision mathematics; displayed decimals are rounded to twelve places. Integer results remain exact in these small cases.

CSCH is the reciprocal of hyperbolic sine. A model that uses a dimensionless ratio x=t/τ can put that ratio in A2 and use =CSCH(A2). At x=0.5 the value is about 1.919034751335. This is a hyperbolic function; an automatic degrees-to-radians conversion is not appropriate for a generic model ratio.

CSCH(x)×SINH(x)=1 for nonzero x. The function is odd, and its magnitude decreases toward zero as |x| grows. For small nonzero x it behaves approximately like 1/x. Another check is COTH(x)^2−CSCH(x)^2=1; use moderate inputs when comparing floating-point calculations.

Zero is undefined and yields a native error in the tested build. A negative argument returns a negative result, rather than an error merely for being negative. Very large arguments can challenge the intermediate hyperbolic calculation even when a mathematical reciprocal is small; such extreme behavior was not tested here.

These additional formulas were recalculated from the same generated ODF input. H5 is a deliberately empty cell where referenced. Error displays are retained as errors, even when an ODS numeric attribute stores zero.

SINH, COSH, TANH.

• Function-specific release entry

The generated ODF input produced the informational load warning “Not all attributes could be read.” After it was acknowledged, the sheet was hard-recalculated and saved separately. Every formula identity, input label and tested result was reconciled, including repeated spaces represented with ODF text elements. This does not certify every style attribute. The separately prepared XLSX input was not executed. A deliberately stale SUM cache changed from 999999 to 3, and an uncached SUM returned 7 after hard recalculation. Native evidence covers the eight reference formulas and listed diagnostics only. Other explanatory compositions are independent mathematical checks; other releases, locales and extreme-value behavior were not established by this run.