PlanMaker IMREAL: Extract the real coefficient without losing the other component

The 2026 function reference, 2024 reference and 2021 reference were retrieved and read on October 15, 2026. They establish documented support in those PlanMaker manual families. The original introduction and any last-working-version endpoint remain unverified; 2021 is the oldest reference checked here, not an introduction claim. Specific FreeOffice/mobile builds and every desktop platform were not tested.

The tables combine documented function rules with independent component arithmetic and high-precision mathematical calculations. No native PlanMaker execution, screenshot, export or import test was performed. Complex result components are used where native string formatting is not established. English examples use commas between arguments; adapt locale syntax only after checking the installed editor.

The single ComplexNumber argument is required; no default or optional selector is documented. SoftMaker’s example is =IMREAL("2+4i"), returning 2. A supported complex value can also be constructed with COMPLEX and passed by cell reference. The imaginary suffix does not become part of the real coefficient.

Create RealComponents, with Real_input, Imag_input, Complex_value, Real_result and Modulus in A1:E1. Enter A:B below. Fill C2 =COMPLEX(A2,B2), D2 =IMREAL(C2) and E2 =IMABS(C2) through row 8.

E is rounded to nine decimals where needed. The real coefficient can be negative or zero even when the magnitude is positive. In particular, zero in D6 does not imply that the entire complex number is zero.

Duplicate the worksheet and change B3 from 4 to 12. D3 remains 3, but E3 becomes approximately 12.369316877, because the magnitude is √153. This is a useful check that D actually extracts the real coefficient rather than another property.

Create ComponentTotals with numeric real/imaginary pairs (3,4), (6,8), (-2,1) in A2:B4. Fill C2 =COMPLEX(A2,B2) through C4. In E2 enter =IMSUM(C2,C3,C4), E3 =IMREAL(E2) and E4 =IMAGINARY(E2).

The independently expected total coefficients are 7 and 13. The separate real sum =IMREAL(C2)+IMREAL(C3)+IMREAL(C4) is also 7. That equality audits componentwise addition; it does not say the overall magnitude is 7. The total modulus is √218, approximately 14.764823060.

On a copy, change A4 from -2 to 2. The total real coefficient becomes 11, while the imaginary total stays 13. A single sign correction in a component changes the projection by four, not two.

On the original RealComponents sheet, put F3 =COMPLEX(IMREAL(C3)+10,IMAGINARY(C3)). Its coefficients are 13 and 4. Extract both again to confirm the transformation. This preserves the imaginary coefficient explicitly instead of turning the extracted real number into a replacement for the original complex value.

If j notation is required, supply "j" as COMPLEX’s third argument. Omitting that suffix chooses the constructor’s documented i default. The mathematical components can remain identical while the visible suffix convention changes.

Check whether you supplied a complex cell reference or a quoted literal. Quoting a cell address passes its characters, not the referenced value. Malformed strings, unsupported suffixes, embedded spaces, large coefficients and numeric coercion require separate native checks; the short reference does not define their full error behavior.

Use IMAGINARY for the other coefficient and IMABS for magnitude. IMCONJUGATE preserves the real coefficient while reversing the imaginary one. These operations answer different questions even when one example happens to return the same number.

Record the exact product/build, edition, platform, locale and workbook format. Enter the full source table, inspect components and apply the changed-input controls on separate copies. Keep full precision for calculations and round only the display. Saved-file recalculation and destination compatibility require their own tests.