IMABS in Collabora Office: Measure Complex Magnitudes and Compare Distances

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

=IMABS("ComplexNumber")

The product reference describes complex text in x+yi or x+yj form and gives the explicit control =IMABS("5+12j"), returning thirteen.

The mathematical magnitude of a+bj is the square root of a²+b². It is nonnegative and does not retain the direction of the original value. Reversing either coordinate’s sign leaves this distance unchanged.

The component equation supplies an independent verification model; it does not prove that a hand-written square-and-root formula shares every native overflow or rounding behavior of IMABS.

Enter only the first text column in A2:A5. Calculate B with =IMABS(A2) filled down.

The sums of squares are 100, 169, 289 and 625. Their square roots give the displayed results.

A magnitude is different from a sum of absolute coordinates. For the first record, 6+8=14, whereas its magnitude is ten. Label the derived column clearly so those different measures are not confused.

In C2 use =IMREAL(A2) and in D2 use =IMAGINARY(A2), filling down. Then calculate:

=SQRT(C2^2+D2^2)

The expected results match B2:B5: 10, 13, 17 and 25. IMREAL and IMAGINARY expose the two numeric coordinates, while SQRT handles the positive squared total.

This check uses moderate integers whose arithmetic is transparent. It should not be generalized into a native numerical-stability claim for extremely large or tiny values.

Let P=7+9j and Q=1+j. Their difference is 6+8j, so:

=IMABS(IMSUB("7+9j";"1+j"))

has independently expected result 10. Reversing the subtraction produces −6−8j and the same distance.

IMSUB retains the directional residual. IMABS removes that direction and reports its length. Use both coefficients when the direction of a discrepancy matters.

For the first record, divide the two coefficients by its magnitude. Expected normalized coordinates are 0.6 and 0.8. Their squares sum to one:

=(6/10)^2+(8/10)^2

Expected numeric result: 1. =COMPLEX(6/10;8/10;"j") constructs a unit-magnitude model with the original direction.

A zero magnitude cannot be used as a normalization denominator. This mathematical prerequisite does not assign a native error code to every zero representation or invalid complex string.

The values 6+8j and 6−8j each have magnitude ten, totaling 20. Their complex sum is 12 with zero imaginary component, whose magnitude is 12.

Thus =IMABS(IMSUM("6+8j";"6-8j")) has expected result twelve, while =IMABS("6+8j")+IMABS("6-8j") gives twenty. IMSUM combines the components before magnitude is taken.

For aligned values 6+8j and 3+4j, the sum is 9+12j with magnitude 15, equal to the individual magnitudes 10+5. Agreement in that aligned case does not establish a universal distribution rule.

Magnitude alone cannot distinguish 6+8j from 6−8j or −6−8j. Preserve the original values when future analysis needs their direction or sign.

The dedicated reference does not provide a complete coercion/error matrix or precise native boundary behavior. All outputs here are independent magnitude calculations or explicit source controls, with no native Collabora execution.

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