Use =ASINH(0.8) to get the independently calculated 0.73266826 (shown to eight decimal places). ASINH reverses SINH: it finds the real value t whose hyperbolic sine is x. Every finite real x is mathematically admissible; there is no real-domain restriction for negative numbers. The output shown here is a mathematically expected value, not an actual Calligra Sheets execution result.

=ASINH(number)

The KDE handbook and the tagged Calligra 26.08.2 trig.xml declare ASINH(Float) and show the expected =ASINH(0.8) example. The associated trig.cpp registers ASINH and calls calc->asinh(args[0]). This checks the one-argument implementation’s documented intent; it is not a test of a packaged Calligra binary. The 26.08.2 KDE Gear release was dated October 8, 2026 (announcement); sources were accessed 2026-10-11. A function’s presence in the handbook and source registry does not guarantee that a particular installed package enables the function or reproduces the same display formatting.

Domain and inverse-function distinction

Every finite real x is mathematically admissible; there is no real-domain restriction for negative numbers. The inverse hyperbolic function is not the ordinary inverse trigonometric function (for example, ASIN). Despite a generic “Angle (radians)” parameter label inherited from the older KDE handbook, the input is normally a dimensionless real number; the output is not an ordinary angle that should be converted to degrees. Do not insert RADIANS or DEGREES automatically.

Formula entry and locale details

Enter =ASINH(A2) in the formula bar. Numbers such as 0.8 are written with a decimal point in this English-language example; your regional numeric conventions may require a comma. The KDE English function examples use semicolons between arguments for multi-argument functions, but this function has exactly one argument, so no separator is needed. If your installation localizes function names, use the function chooser; no native localized system or conversion was tested.

1. In a blank sheet, enter Numeric x into A1 and ASINH(x) into B1.
2. Type the six numeric inputs into A2:A7, in the exact order below; these are numeric values, not quoted strings.
3. In B2, enter =ASINH(A2) and fill/copy the formula through B7. The relative A2 reference must increment to A3, A4, etc.
4. Format column B to eight decimal places and compare within a small tolerance (for example 0.00000001 plus a sensible floating-point margin).

All displayed outputs were independently calculated using Python math.asinh and then rounded for presentation on 2026-10-11. They were not observed by running Calligra or importing a workbook. Hand-calculated identities and independently evaluated numerical examples complement documentation checking; they do not replace real spreadsheet validation. Displaying eight decimals does not alter underlying floating-point precision.

Cross-check with its paired hyperbolic function

The mathematical inverse relationship is SINH(ASINH(x)) = x. =ASINH(SINH(1)) is expected to return 1 within floating-point tolerance. Likewise =ASINH(-2) should be the negative of =ASINH(2); the inverse hyperbolic sine is an odd function. A direct mathematical identity is ASINH(x)=LN(x+SQRT(x^2+1)). For very large negative x, evaluating this logarithm directly can suffer cancellation; prefer the built-in ASINH rather than assuming the identity is equally numerically stable.

If you have signed data that includes large positive and negative measurements, ASINH can compress the range while preserving sign and permitting zero—unlike LN(x), which is undefined for nonpositive real x. Place 10 (a strictly positive scale) in E2 and a measurement -20 in F2. Enter =ASINH(F2/E2) in G2. Independent math expects -1.44363548. To invert that transform, enter =E2*SINH(G2) in H2; the expected recovered measurement is approximately -20. The scale must be positive and in the same units as the measurement so F2/E2 is dimensionless; use a tolerance for round-trip checks. This is a data transformation, not a recommended statistical model without context.

• Negative inputs are valid. Unlike LN on real numbers, ASINH(-1) is mathematically valid; a negative result is not itself an error.
• Very large inputs. The native numeric implementation has finite range. Avoid computing the naive identity with x^2 for huge magnitudes, since the square can overflow even when ASINH(x) itself would be representable.
• Wrong inverse. ASINH reverses hyperbolic sine, whereas ASIN reverses ordinary sine on its principal interval. Do not use RADIANS() or DEGREES() to transform hyperbolic results into ordinary angles.
• Unrecognized formula: Verify the function spelling, leading =, and that your installed package includes the trigonometry function module. A release registration is not proof of behavior in a particular installation.
• Text versus numeric data: Imported strings, numbers stored as text, and units such as "2 units" are not documented floating-point numeric arguments. Native coercion rules and resulting error strings have not been checked.
• Rounding and display: Check actual stored input cells and show more decimal places before assuming the function result is wrong. Round-trip identities should be compared with tolerance, not strict equality in every case.
• Regional settings: If the example formula appears as text or parses unexpectedly, check cell format, decimal conventions and localized formula entry. No locale-specific native test was run.

The official Excel ASINH(number) contract accepts any real number, matching the mathematical domain in this guide. LibreOffice Calc documents hyperbolic functions as well. Identical names and one-argument signatures support formula-level compatibility in principle, but no workbook import/export, localization, coercion or native cross-software execution has been verified.

The comparison uses the official Microsoft Excel ASINH help and LibreOffice Calc mathematical functions, accessed 2026-10-11; neither application was executed. Mathematical agreement does not establish identical parsing, coercion, domain errors, decimal formatting or workbook compatibility.

• Official SINH function reference — paired hyperbolic function, for checking the inverse identity.
• Official ASINH function reference — exact signature and built-in examples.
• KDE Calligra 26.08.2 trigonometry descriptions and registered C++ implementation — released code, not native test output.
• KDE Gear 26.08.2 release and Calligra downloads — release/platform scope; Linux packages and Flatpak are recommended, while Windows support is listed as in progress.

These are checked official external documentation/source destinations. The proposed future internal tutorial slug is /calligra/functions/asinh/, but it has not been published or verified as a live page; do not assume the links are working internal pages.

• Calligra Sheets — function documentation
• 26.08.2 trig.xml
• KDE tagged trig.cpp
• announcement
• LibreOffice Calc mathematical functions
• Official SINH function reference

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Calligra Sheets.

• No genuine Calligra Sheets screenshots are included; this guide does not use mock application images.