IMCONJUGATE in Collabora Office: Reverse Imaginary Signs and Audit Conjugate Products

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

=IMCONJUGATE("ComplexNumber")

The Collabora reference describes complex text in x+yi or x+yj form. Its explicit example converts 1+j to 1−j.

Conjugation maps a+bj to a−bj. Geometrically it reflects the point across the real axis. It differs from ordinary negation, which changes both coefficients’ signs.

The short source does not provide a complete malformed-text or coercion/error table. The worked strings are explicit complex values with consistent lowercase j notation.

Enter only the first text column in A2:A5. In B2 enter =IMCONJUGATE(A2) and fill down.

The third and fourth imaginary coefficients begin negative and become positive. Conjugation is therefore not simply “make the imaginary coefficient negative.”

The last expected quantity may be written without its zero real coefficient. Exact native text rendering or storage TYPE is not certified by that mathematical simplification.

For the original fixture, =IMREAL(A2) filled down gives 6, −3, 2 and 0, while =IMAGINARY(A2) gives 8, 4, −5 and −7.

Apply the same functions to B2:B5. The real sequence remains unchanged, and the imaginary sequence becomes −8, −4, 5 and 7.

IMREAL and IMAGINARY make the defining sign rule visible. Comparing just magnitudes would not prove that the correct sign was reversed.

Use =IMCONJUGATE(B2) in C2 and fill down. The reconstructed quantities are the originals. Both component comparisons should be TRUE:

=IMREAL(C2)=IMREAL(A2)
=IMAGINARY(C2)=IMAGINARY(A2)

This identity concerns quantities, not character-for-character text. An original string with an explicit zero real term may be reconstructed in a simpler written form.

For each row, use =IMPRODUCT(A2;B2). Expected real coefficients are 100, 25, 29 and 49; expected imaginary coefficients are all zero.

For the first row, the real calculation is 6×6−8×(−8)=100. The imaginary calculation is 6×(−8)+8×6=0. In general the result is a²+b².

IMPRODUCT performs the complete multiplication. The result also equals the square of IMABS mathematically, which is a separate magnitude check.

For (6+8j)/(2−j), the denominator’s conjugate is 2+j. Multiplying the numerator by it gives 4+22j; multiplying the denominator by it gives 5 with zero imaginary component.

The quotient therefore has components 4/5 and 22/5, or 0.8 and 4.4. =IMDIV("6+8j";"2-j") provides the corresponding function call under the IMDIV contract.

The denominator must be nonzero for this mathematical derivation. A native zero-divisor error code is not established by the conjugate section.

For 6+8j, the conjugate is 6−8j, negation is −6−8j, and the reciprocal has components 0.06 and −0.08, obtained by dividing the conjugate by one hundred.

These are distinct operations. A column labeled Inverse should not contain raw conjugates unless the additional magnitude condition justifies that equality.

The sum of the first value and its conjugate has real coefficient 12 and imaginary coefficient 0. This offers another exact check without requiring a native storage-type assumption.

All examples use moderate coefficients and retain exact fractions when useful. Native parsing of alternative forms, mixed-suffix interactions, blank coercion and extreme precision limits remain unverified. The outputs are independent calculations supported by the documented conjugate meaning.

• Collabora Office 26.04: IMCONJUGATE.
• 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.