ASINH in Collabora Office: Apply an Inverse Hyperbolic Sine Transform

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Direct function-specific documentation and independent numerical examples; no native Collabora test was performed.

=ASINH(number)

number is the value whose hyperbolic sine is sought in reverse. If y=ASINH(x), the mathematical inverse check is SINH(y)=x. SINH is the corresponding forward function.

Hyperbolic functions are based on exponential relationships. Do not add a RADIANS conversion merely because the name includes sine. The input here is a numeric quantity or a dimensionless ratio defined by the model, rather than an ordinary degree angle.

Examples use English function names and semicolon separators when another function requires more than one argument. Displayed decimals are rounded expectations, not native screenshots.

Enter −2, −1, 0, 1, 2 in A2:A6. In B2 enter and fill down:

=ASINH(A2)

Expected B2:B6, approximately: −1.443635475, −0.881373587, 0, 0.881373587, 1.443635475. The output preserves the input’s sign. Equal opposite inputs have equal opposite outputs.

The result is not a reciprocal. For input 2, ASINH is approximately 1.443635475, while 1/2 is 0.5. Inverse function and reciprocal mean different operations.

=SINH(ASINH(2))
=ASINH(SINH(-2))

Expected results, within numerical precision: 2 and −2. Both directions are useful controls when a larger formula combines forward and inverse transformations.

Keep the complete calculated value in the cell. If you copy only a displayed rounded decimal into the next calculation, the reconstructed input may differ slightly because you have discarded precision.

For the illustrative values −100, −10, 0, 10, 100, ASINH gives approximately:

Large magnitudes are compressed while zero remains defined. This can be useful in a deliberately chosen numerical transformation, but the table does not establish that the transform is appropriate for any particular dataset or analysis.

Keep original values beside transformed ones and label the transformed axis or column clearly. An ASINH value is not in the same scale as the original measurement.

Suppose a model defines a reference scale of 10 units in D1 and an input of 100 in D2. Use:

=ASINH(D2/$D$1)

Expected result: approximately 2.998222950. Dividing by the reference scale first creates the intended dimensionless input 10. If that result is in E2, recover the original scale with:

=$D$1*SINH(E2)

Expected result: approximately 100. The absolute reference keeps D1 fixed if the formula is copied. The scale must be chosen for the model and kept nonzero; ASINH does not decide a meaningful scale automatically.

With an input of −100 and the same positive scale, the transformed result is approximately −2.998222950 and the inverse reconstruction is approximately −100. Test both signs when the data is signed.

For moderate inputs, the real-valued identity is:

=LN(A2+SQRT(A2^2+1))

At A2=1 this is approximately 0.881373587, matching ASINH. The expression is useful for understanding the relationship with LN and SQRT.

Do not replace the dedicated function everywhere with this hand-built expression. Squaring a very large input can overflow, and a large negative input can make the addition subtract nearly equal magnitudes. Algebraically equivalent formulas can have different numerical stability.

The mathematical real domain includes all real numbers. This guide does not certify arbitrary text coercion, infinite inputs or extreme-magnitude behavior in a native Collabora instance. Begin with zero and the small signed controls, then test the actual data range.

If an answer resembles an angle, check whether you intended ASIN instead. If you expected the original input back, confirm that you paired ASINH with SINH rather than SIN, COSH or a reciprocal. A function name is not enough to establish the intended mathematical relationship.

• Collabora Office 26.04: ASINH.
• Editorial testing standards.

The official section supplies the product-specific definition and documented domain or angle branch. Original worked values were independently calculated. Native execution, extreme-value benchmarks and broader client compatibility remain unverified.