IMEXP Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Engineering module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Formulas were executed through the official 25.04.2 engine library and checked against source and independent mathematics. This is not GUI-cell or workbook-import evidence; 26.08.2 was source-checked, not executed.

IMEXP evaluates e^z for a complex input z=a+bi. Its real and imaginary components are e^a cos(b) and e^a sin(b). The imaginary input is an angle in radians; the real input controls the magnitude. Function help.

=IMEXP(complexValue)

Exactly one complex value is required. Numeric inputs are treated as having zero imaginary component. Use COMPLEX(real;imaginary) when constructing inputs from separate worksheet columns. Registration and implementation, with versioned help.

Results are shown as (real,imaginary) component pairs, rounded to twelve decimal places, not a literal cell format. A component rounded to zero is shown as 0; the stored value may still contain a tiny residual or signed zero. NaN means not-a-number; infinity and NaN are not finite results.

For a pure imaginary angle, =IMEXP(COMPLEX(0;1)) gives approximately 0.540302305868+0.841470984808i. Its magnitude is 1. By contrast, a real input of 1 gives e, approximately 2.718281828459, with zero imaginary component.

If an input angle is supplied in degrees, convert it to radians before placing it in the imaginary component. An angle of 180° corresponds to PI(), not the numeric value 180. Label the angle’s unit so a later edit does not silently change the interpretation.

The executed Euler-identity check =IMEXP(COMPLEX(0;PI())) returned real component −1 and imaginary component approximately 1.224646799147E-16. That tiny residual reflects the finite representation of PI() and numerical evaluation; it is not an additional physical signal.

For a+bi, the magnitude is e^a and the phase repeats every 2π. Adding an integer multiple of 2π to b leaves the exact mathematical result unchanged. This periodicity also means a subsequent principal logarithm cannot always recover the original imaginary input.

Invalid text “abc” and an empty string became zero, so their exponentials returned (1,0). This is especially easy to mistake for a valid neutral factor. TRUE became the real input 1. Validate text before interpreting an apparently reasonable exponential result.

The moderate table inputs do not establish behavior for arbitrarily large real parts, where exponential growth can overflow, or very negative ones, where it can underflow. Zero or two arguments produced #VALUE!. The engine’s component representation is not a claim about cell formatting.

The complex conversion helper explains the text and Boolean cases above. The inspected Engineering module and complex converter are byte-identical between 25.04.2 and 26.08.2. That source comparison does not establish every locale, import path or extreme-value case.

Use COMPLEX to construct values from numeric components, IMABS for magnitude, and IMARGUMENT for principal phase.