CSCH Function (LibreOffice Calc)
Evaluate LibreOffice CSCH with tested positive and negative inputs, zero-error behavior, hyperbolic identities and near-zero sensitivity explained.
Verification status: Eight reference formulas and 8 diagnostic cases were recalculated through XLSX import in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5. This is headless development-build evidence; no stable-release or GUI execution is claimed. How formula examples are checked
Availability and version history
- Introduced: LibreOffice 3.5.
- Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
- Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
- Checked: 2026-10-14 — function reference; versioned support. Release availability is source-checked. The native examples below have their own named development-build scope.
Quick answer: =CSCH(0.5) has mathematical value approximately 1.919034751335, matching the ordinary development-build example below.
What CSCH returns
CSCH is the reciprocal of hyperbolic sine: CSCH(x)=1/SINH(x). For real nonzero x, its sign follows x and its magnitude decreases as |x| increases. Its input is a real, dimensionless argument rather than an ordinary circular angle; there is no automatic reason to convert a model parameter from degrees. Pinned LibreOffice evaluator.
Syntax and arguments
=CSCH(Number)
Supply one numeric argument. Zero is outside the mathematical domain of the reciprocal. A referenced blank becomes zero in the tested call and therefore also reaches that undefined point. TRUE becomes 1. Negative real inputs are valid; the function is odd, so CSCH(−x)=−CSCH(x).
Eight reproducible examples
These formulas were recalculated through XLSX import in LibreOfficeDev 26.8.0.0.alpha0, build 2c87e51eeaa2b413ff4ae097b2705eea1995d8e5. Saved values agree with independent high-precision mathematics. Values below are rounded to twelve decimal places; scientific notation uses thirteen significant digits.
| Formula | Saved native value | Independent reference |
|---|---|---|
=CSCH(0.25) |
3.958635163302 |
3.958635163302 |
=CSCH(0.5) |
1.919034751335 |
1.919034751335 |
=CSCH(1) |
0.850918128239 |
0.850918128239 |
=CSCH(2) |
0.275720564772 |
0.275720564772 |
=CSCH(-0.25) |
-3.958635163302 |
-3.958635163302 |
=CSCH(-0.5) |
-1.919034751335 |
-1.919034751335 |
=CSCH(-1) |
-0.850918128239 |
-0.850918128239 |
=CSCH(-2) |
-0.275720564772 |
-0.275720564772 |
Practical worksheet
Evaluate a dimensionless model ratio
Suppose a model requires CSCH(t/Ï„), with t in A2 and a positive scale Ï„ in B2, expressed in the same units. Use =CSCH(A2/B2). If their ratio is 0.5, the value is approximately 1.919034751335. This formula illustrates how units cancel; it does not establish that this hyperbolic shape is suitable for every decay or transfer model.
At ratio 2, CSCH is approximately 0.275720564772. It is not exactly an exponential decay: the identity CSCH(x)=2/(EXP(x)−EXP(−x)) contains two exponentials, although for large positive x its leading behavior is 2×EXP(−x).
Advanced interpretation
Check signs and identities
At x=1, CSCH(x) is approximately 0.850918128239. Multiplying by SINH(x) gives 1 mathematically. The paired negative rows check the odd symmetry independently. COTH(x)^2−CSCH(x)^2=1 is another identity for real nonzero x; subtraction of large terms near zero can lose numerical precision.
Near zero versus large positive inputs
For a small nonzero argument, sinh(x)≈x, so CSCH(x)≈1/x. The native 0.000001 case is close to one million but is not exactly one million. Small input uncertainty near zero can therefore create large output changes. Exclude or flag unsuitable model inputs rather than merely formatting away the large magnitude.
The separately checked input 20 gives a small positive result, close to 2×EXP(−20). This one finite case does not establish behavior for arbitrary large arguments: an intermediate SINH calculation may face floating-point range limits even when the exact reciprocal would be small.
Boundaries and troubleshooting
The real pole is at zero, not at integer multiples of π. An explicit IF(A2=0;"Undefined";CSCH(A2)) can handle that exact numeric input when it is appropriate for the data model; near-zero sensitivity still needs its own policy. The diagnostic table records the actual error display for zero and blank input. It does not borrow the error code of an independently entered division expression. Non-numeric text and excess arguments remain distinct failures.
Development-build diagnostics
In this run, zero and a blank reference produced #NUM!. The additional formulas use the same headless import path. H5 is an actually empty cell. The table uses saved numeric values or exact error displays; retained application display text can round a numeric value differently in its last printed place.
| Formula | Saved result or error |
|---|---|
=CSCH(0) |
#NUM! |
=CSCH("abc") |
#VALUE! |
=CSCH(H5) |
#NUM! |
=CSCH(1;2) |
Err:508 |
=CSCH(TRUE()) |
0.850918128239 |
=CSCH(-3) |
-0.099821569669 |
=CSCH(0.000001) |
999999.999999832944 |
=CSCH(20) |
4.122307244877E-9 |
Related functions
Evidence and checking scope
The LibreOffice 26.8.1.1 source evaluates a reciprocal of the hyperbolic sine function. Native observations cover only the eight reference formulas and listed diagnostics in the named development build. A deliberately stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7 after forced recalculation. Formula identities, error displays and blank input were checked. Other composite explanations are mathematical checks; no stable-release, GUI or exhaustive extreme-input behavior is inferred.