Complex numbers
(Open Document compatibility)

Open Document (and Microsoft Excel) compatible complex numbers[1] are represented by text strings[2], where lower-case suffixes i or j denote the imaginary part.

Example:

"0+1i"

may be used to represent the complex number i, the square root of -1.

Complex numbers should always be manipulated using the appropriate complex number function.

Fireworkz "C_"-prefixed complex number functions may be used in addition to the compatibility "ODF.IM"-prefixed engineering functions.

A single real number may be passed to complex number functions, where it behaves as the real part of a complex number with an imaginary part of zero.

Where a function takes a pair of complex numbers and an imaginary number suffix is specified on both numbers, both numbers need not use the same suffix and 'i' will dominate. Microsoft Excel would require both suffixes to be the same.

Revisions:

Support for complex number strings was added in 2.00.

  1. Weisstein, Eric W. "Complex Number." From MathWorld--A Wolfram Web Resource. http://mathworld.wolfram.com/ComplexNumber.html
  2. "Open Document Format for Office Applications (OpenDocument) Version 1.2 Part 2: Recalculated Formula (OpenFormula) Format". 29 September 2011. OASIS Standard. http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ConversionToComplexNumber