SINH in Collabora Office: Calculate Hyperbolic Sine and Signed Growth Differences
Use hyperbolic sine in Collabora Office with exponential identities, signed inputs and reproducible numeric checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: SINH returns the hyperbolic sine of a number. =SINH(0) is expected to return 0. It is different from the circular sine function SIN and is not a periodic angle conversion.
Availability and version history
- Introduced: documented in Collabora Office 26.04 Help; the original introduction version is not established by the reviewed history.
- Availability: the official SINH reference documents support in Calc’s 26.04 desktop manual.
- Scope: this evidence does not establish identical behavior in Collabora Online, mobile clients or older releases.
- Checked: October 14, 2026 against the captured 26.04 manual. Examples were calculated independently; no native Collabora execution was performed.
Syntax and mathematical meaning
=SINH(number)
The official help identifies the function as hyperbolic sine. Its mathematical definition is:
sinh(x) = (exp(x)-exp(-x))/2
This identity explains the independently calculated examples below. Use a dimensionless input or the dimensionless quantity defined by your model; do not automatically convert it from degrees simply because the function name resembles SIN.
Hyperbolic sine is unbounded, increases as its input increases and changes sign when the input changes sign. It is not constrained to the interval from −1 to 1.
Example 1: calculate a symmetric input list
Enter −2, −1, 0, 1, 2 in A2:A6. In B2 enter and fill down:
=SINH(A2)
Expected B2:B6: approximately −3.626860408, −1.175201194, 0, 1.175201194, 3.626860408.
The values at ±1 and ±2 have matching magnitudes and opposite signs. This is the odd-function identity sinh(−x) = −sinh(x). A negative result is mathematically appropriate for a negative input.
Example 2: verify the exponential definition
Put 1 in D2 and compare:
=SINH(D2)
=(EXP(D2)-EXP(-D2))/2
Expected result for both: approximately 1.175201194. EXP supplies the exponential terms. Their values at x=1 are approximately 2.718281828 and 0.367879441; half their difference is the stated hyperbolic sine.
The expanded expression is a teaching check, not a promise that two different computational paths produce identical last bits. Specialized function implementations can behave differently from a manually expanded expression for extreme or very small values.
Example 3: an input with a simple expected result
=SINH(LN(2))
Expected result: approximately 0.75. Because exp(ln 2) is 2 and exp(−ln 2) is 1/2, the definition gives (2−1/2)/2 = 3/4.
For =4*SINH(LN(2)), the expected result is approximately 3. The scaling factor multiplies the result; it does not change the input logarithm.
LN is the natural logarithm. Substituting a base-10 logarithm would describe a different calculation.
Advanced example: compare a model at positive and negative offsets
For an illustrative scaled function, put 2 in F1 and offsets −1, −0.5, 0, 0.5, 1 in D5:D9. In E5 enter and fill down:
=$F$1*SINH(D5)
Expected E5:E9: approximately −2.350402387, −1.042190611, 0, 1.042190611, 2.350402387.
The model is deliberately symmetric about zero. It can illustrate a signed nonlinear transformation, but the formula alone does not establish that any particular physical or business process follows it. Retain the original offsets and the chosen scaling parameter.
Advanced example: check the hyperbolic identity
For a moderate input of 1:
=COSH(1)^2-SINH(1)^2
Expected result: approximately 1. COSH and SINH satisfy a difference-of-squares identity. This differs from the sum-of-squares identity for circular SIN and COS.
At large magnitudes, subtracting two large nearly equal squared values can lose accuracy. This is a useful moderate-input teaching check, not a preferred way to compute a constant or a universal stress test for extreme inputs.
Troubleshooting and precision
Do not use SINH as a spelling variant of SIN. SINH(1) is about 1.1752, whereas SIN(1 radian) is about 0.84147. Neither result is a percentage unless your surrounding model defines it that way.
Large positive and negative magnitudes grow rapidly in absolute value. A mathematically finite result can exceed a spreadsheet’s numeric representation. This guide does not promise an exact overflow threshold or error code for every release.
Keep units, signs and the scale parameter explicit. Validate a zero input, one positive input and its negative before extending a model. Independently calculated values should be checked with a sensible tolerance rather than exact text equality after rounding.
References and verification
- Collabora Office 26.04 Help: SINH — direct product-specific definition and syntax.
- Editorial testing standards.
The examples use semicolon argument separators. Displayed decimals are rounded expected values, not exact native outputs. Mathematical identities are explanatory calculations; product support is limited to the cited documentation scope.