COMPLEX in Collabora Office: Construct Complex Values from Two Numeric Coefficients

• 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.

=COMPLEX(RealNum; INum [; Suffix])

RealNum is the real coefficient; INum is the imaginary coefficient. The optional suffix is described as a choice of i or j. The dedicated Collabora section does not state what an omitted suffix becomes, so every worked construction here supplies “j” explicitly.

The numeric coefficient 8 is different from the already formatted text “8j”. Supply the numeric parts to the two coefficient arguments, and let the function assemble the complex representation.

The reference directly demonstrates =COMPLEX(3;4;"j") returning 3+4j. It does not give a full accepted-type, invalid-suffix or error table. The examples avoid uppercase suffixes and uncertain coercions.

Enter only the two numeric input columns in A1:B5. Calculate C2:C5 with =COMPLEX(A2;B2;"j"). The last column below is expected output.

The final quantity has zero real coefficient. Its simplified written form is 7j; this is a quantity-level expectation, not a certificate of every native display or storage-type detail.

Use =IMREAL(C2) and =IMAGINARY(C2) in D2:E2, then fill down. Expected real coefficients are 6, −3, 2, 0, and imaginary coefficients are 8, 4, −5, 7. Comparing them with A and B gives TRUE on every row.

Enter (6,8) and (2,−1) in G2:H3. The two values are 6+8j and 2−j. Add corresponding coefficients:

=COMPLEX(G2+G3;H2+H3;"j")

Expected quantity: 8+7j. Subtracting the second value instead gives =COMPLEX(G2-G3;H2-H3;"j"), or 4+9j.

These formulas use ordinary arithmetic on numeric coefficient cells. They do not assume that a general plus operator knows how to add arbitrary complex-looking text.

For (a+bj)(c+dj), j squared equals −1. The real coefficient is ac−bd and the imaginary coefficient is ad+bc. With G2:H3, use:

=COMPLEX(G2*G3-H2*H3;G2*H3+H2*G3;"j")

Expected quantity: 20+10j. The real calculation is 6×2−8×(−1)=20; the imaginary calculation is 6×(−1)+8×2=10.

If the real calculation mistakenly used addition instead of subtraction, it would give four, producing a different value. A visible helper calculation is useful when auditing sign mistakes.

For 6+8j, =COMPLEX(6;-8;"j") constructs its conjugate, 6−8j. Multiplying the two mathematically gives real coefficient 100 and imaginary coefficient 0.

The original magnitude is =SQRT(6^2+8^2), or 10. Squaring that magnitude gives 100, independently matching the conjugate product. IMCONJUGATE and IMABS provide dedicated operations under their own reference contracts.

IMREAL and IMAGINARY extract the two coefficients for inspection. Both must match before a reconstructed quantity can be called equal; matching only one loses information.

A j suffix and an i suffix denote the same mathematical imaginary unit here, but native mixed-suffix combinations are not certified by this source. Keep one explicit suffix throughout a fixture. Omitted suffix behavior, numeric-text coercion, malformed inputs, exact errors and degenerate output TYPE remain unverified.

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

Complete function-specific documentation reviewed. Outputs are independent complex-component models or explicit documented controls, not captured native application results. Formulas use English names and semicolon separators; optional-argument brackets describe syntax and are not typed into working formulas.