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

IMREAL returns a from the complex number a+b·i. Its output is a real numeric value. The imaginary component is discarded, not combined with the real component. For example, both 3+4i and 3−4i have real part 3. Function help.

=IMREAL(complexValue)

Exactly one complexValue argument is required. Values constructed with COMPLEX supply the two components directly. A plain real number is treated as a complex value with zero imaginary part, so extracting its real component leaves that number unchanged. Valid tested i and j text forms are also accepted. Registration and implementation, with versioned help.

Noninteger results are rounded to twelve decimal places. The formulas construct the input components explicitly, making each case reproducible.

Enter −3 in A2 and 4 in B2. =IMREAL(COMPLEX(A2;B2)) returns −3. Pairing that extraction with IMAGINARY is useful when checking that two-column measurements were assembled in the right order. Swapping the real and imaginary columns would change the extracted result.

The recorded =IMREAL(IMCONJUGATE(COMPLEX(3;4))) returns 3. Conjugation reverses the imaginary coefficient but leaves the real component intact. That makes a convenient transformation check alongside an imaginary-component sign check.

The real part of 0+4i is zero even though its magnitude is 4. Likewise, a negative real component is a coordinate, not a negative magnitude. Keep a and b available whenever later calculations require the full complex value; IMREAL alone cannot reconstruct the discarded component.

Invalid text “abc” and an empty string returned 0 in the tested engine. The shared converter substitutes a zero complex value when parsing does not produce a number, and this function does not inspect that failure flag. A returned zero is therefore not proof of a valid purely imaginary input.

TRUE returned 1, and a missing argument returned #VALUE!. Use deliberate input validation for imported fields, especially where a genuine zero coordinate and malformed data have different meanings. The examples do not establish every locale or array-conversion behavior.

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.