IMEXP in Collabora Office: Separate Complex Exponential Growth from Rotation

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=IMEXP("ComplexNumber")

The argument uses the documented x+yi or x+yj form. The dedicated section identifies e as approximately 2.71828182845904 and supplies the 1+j example, but does not give a full coercion or error table.

For a real coefficient a and imaginary coefficient b, the mathematical identity is e^(a+bj)=e^a×(cos(b)+j×sin(b)). The imaginary coefficient is an angle in radians in this model. It controls rotation; the real coefficient controls the magnitude e^a.

The examples below are independently calculated applications of that definition. They do not certify exact native string formatting, limits or bit-for-bit precision.

Format A2:A5 as Text and enter the exact ASCII strings 1+j, 2+j, 1-j and j. Put =IMEXP(A2) in B2, then =IMREAL(B2) and =IMAGINARY(B2) in C2:D2. Fill all three down.

Coefficients are rounded to nine decimals for display. Use the unrounded B results in later formulas. The first row reproduces the official rounded control at greater independently calculated precision.

Changing the real input from one to two multiplies both output coefficients by e. Changing the imaginary input from one to negative one reverses the imaginary output’s sign while leaving the real output unchanged.

Put numeric coefficients 1 and 1 in F2:G2. Calculate:

=COMPLEX(EXP(F2)*COS(G2);EXP(F2)*SIN(G2);"j")

This has the same expected coefficients as the first table row. COMPLEX receives numeric parts, and the explicit suffix keeps the representation consistent.

The expression uses EXP, COS and SIN on real numeric inputs. Supplying 57.2957795 instead of one would feed a different radian angle, not relabel the same one-radian input as degrees.

Put =IMABS(B2) in E2 and fill down. Expected magnitudes are 2.718281828, 7.389056099, 2.718281828 and 1, rounded to nine decimals.

For the first row, the independently calculated squared coefficients sum to e². The output is not merely e multiplied by the original complex number: e×(1+j) would have equal real and imaginary coefficients, unlike the actual exponential model.

The fourth row, input j, lies on a unit-magnitude output circle. Its cosine and sine coefficients satisfy cos²(1)+sin²(1)=1. A floating-point reproduction can be checked with a stated tolerance rather than exact decimal equality.

Use the exact input strings 1+j and 1-j. Compare:

=IMPRODUCT(IMEXP("1+j");IMEXP("1-j"))
=IMEXP(IMSUM("1+j";"1-j"))

The independently expected quantity is e², approximately 7.389056099, with zero imaginary coefficient. Multiplying conjugate outputs cancels their imaginary terms while multiplying their magnitudes.

A second control compares IMEXP of 2+2j with the product of two IMEXP outputs for 1+j. The expected coefficients are −3.074932321 and 6.718849697. A negative real output is possible even though the magnitude remains positive.

IMPRODUCT multiplies complex quantities, whereas ordinary multiplication of the displayed text is not the operation demonstrated here.

For a component-level reconstruction, compare IMREAL and IMAGINARY differences against 1e-9 on these modest inputs. Treat that as a verification target for this fixture, not a vendor precision guarantee.

Very large positive real coefficients can exceed a native numeric range; very negative ones can underflow. The dedicated source does not establish those cutoffs or exact errors. Malformed input, mixed suffixes and text/numeric coercion also remain outside this guide’s tested contract. No global logarithm-branch inverse rule is inferred from the exponential examples.

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

Complete dedicated function section reviewed. Results are independently calculated mathematical controls or explicit published examples, not captured native application results. Formulas use English names and semicolon separators.