IMEXP Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this identifies a verified release, not a final supported version.
• Scope: Desktop Calc with its Analysis add-in, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight reference formulas and the listed diagnostics were recalculated after XLSX import in 4.1.16 on Linux x86-64, Build 9816. Source and independent reference calculations were also checked.

IMEXP returns e raised to a complex argument. For a+bi the result is eᵃ(cos b+i sin b), formatted as complex-number text. The imaginary component of the input is an angle in radians, not degrees. Release entry.

=IMEXP(ComplexNumber)

One complex-number argument is required. Valid pure real inputs and lowercase i/j forms are parsed by the add-in. Invalid strings are rejected; an empty string is not automatically interpreted as a deliberate zero. The formatter requires finite output components.

The native column records the saved 4.1.16 results. The native strings are retained exactly. Independent component references are rounded to twelve decimal places, with rounded negative zero shown as zero. A tiny stored residual can therefore appear in the native string beside a reference component rounded to zero. Every successful result below is string-typed, including pure real-looking outputs.

=IMEXP("3+4i") combines magnitude e³ with phase 4 radians. Its components are approximately −13.128783081462 and −15.200784463068. Both signs follow the angle’s quadrant; the real input 3 does not mean the output must have a positive real component.

For an angle θ alone, the imaginary input iθ gives a unit-magnitude exponential. Construct a value from validated numeric components with COMPLEX when using cells, rather than assembling an unvalidated string by hand.

Euler’s formula gives exp(a+bi)=exp(a)(cos b+i sin b). Therefore the output magnitude is exp(a), and exp(z)exp(−z)=1 mathematically. The imaginary input repeats with period 2π, so exp(z+2πi)=exp(z).

For the pure imaginary input i, the components are cos(1) and sin(1). For the real input 1, the result is e with zero imaginary component. The explicit zero diagnostic returns 1.

Although exp(log z)=z on the selected logarithm branch for nonzero z, log(exp z) can differ from z by a multiple of 2πi. The principal logarithm does not retain an arbitrary unwrapped input phase.

Large positive real parts can overflow; very negative real parts can underflow. The trigonometric part also depends on accurate argument reduction for large imaginary values. The modest examples do not establish universal extreme-value accuracy.

The output is formatted text, and a pure real-looking string remains a complex-function result. The lowercase j example below checks a suffix convention, not a change from radians to another unit. Do not infer that uppercase suffixes or arbitrary imported text are accepted.

These additional formulas were recalculated through the same import path. Error displays are retained as errors, even when an ODS numeric attribute stores zero.

The IMEXP guide for Calligra Sheets documents that product’s own syntax and tested behavior. A shared function name does not guarantee the same argument conversion, text parsing, branch or precision rules.

• Function-specific release entry
• Complex algorithm or collection helper
• Strict complex-string parser
• Finite-output string formatter

The saved ODS retained every tested formula identity. 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.