# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/Engineering/Complex.php

TablePress – Tables in WordPress made easy, version 3.4. 121 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Engineering/Complex.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/Engineering/Complex.php
- Modified: 2025-08-26T04:06:14+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Engineering/Complex.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Engineering;

use TablePress\Complex\Complex as ComplexObject;
use TablePress\Complex\Exception as ComplexException;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

class Complex
{
	use ArrayEnabled;

	/**
	 * COMPLEX.
	 *
	 * Converts real and imaginary coefficients into a complex number of the form x +/- yi or x +/- yj.
	 *
	 * Excel Function:
	 *        COMPLEX(realNumber,imaginary[,suffix])
	 *
	 * @param mixed $realNumber the real float coefficient of the complex number
	 *                      Or can be an array of values
	 * @param mixed $imaginary the imaginary float coefficient of the complex number
	 *                      Or can be an array of values
	 * @param mixed $suffix The character suffix for the imaginary component of the complex number.
	 *                          If omitted, the suffix is assumed to be "i".
	 *                      Or can be an array of values
	 *
	 * @return array<mixed>|string If an array of numbers is passed as an argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function COMPLEX($realNumber = 0.0, $imaginary = 0.0, $suffix = 'i')
	{
		if (is_array($realNumber) || is_array($imaginary) || is_array($suffix)) {
			return self::evaluateArrayArguments([self::class, __FUNCTION__], $realNumber, $imaginary, $suffix);
		}

		$realNumber = $realNumber ?? 0.0;
		$imaginary = $imaginary ?? 0.0;
		$suffix = $suffix ?? 'i';

		try {
			$realNumber = EngineeringValidations::validateFloat($realNumber);
			$imaginary = EngineeringValidations::validateFloat($imaginary);
		} catch (Exception $e) {
			return $e->getMessage();
		}

		if (($suffix === 'i') || ($suffix === 'j') || ($suffix === '')) {
			$complex = new ComplexObject($realNumber, $imaginary, $suffix);

			return (string) $complex;
		}

		return ExcelError::VALUE();
	}

	/**
	 * IMAGINARY.
	 *
	 * Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
	 *
	 * Excel Function:
	 *        IMAGINARY(complexNumber)
	 *
	 * @param array<mixed>|string $complexNumber the complex number for which you want the imaginary
	 *                                         coefficient
	 *                      Or can be an array of values
	 *
	 * @return array<mixed>|float|string (string if an error)
	 *         If an array of numbers is passed as an argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function IMAGINARY($complexNumber)
	{
		if (is_array($complexNumber)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
		}

		try {
			$complex = new ComplexObject($complexNumber);
		} catch (ComplexException $exception) {
			return ExcelError::NAN();
		}

		return $complex->getImaginary();
	}

	/**
	 * IMREAL.
	 *
	 * Returns the real coefficient of a complex number in x + yi or x + yj text format.
	 *
	 * Excel Function:
	 *        IMREAL(complexNumber)
	 *
	 * @param array<mixed>|string $complexNumber the complex number for which you want the real coefficient
	 *                      Or can be an array of values
	 *
	 * @return array<mixed>|float|string (string if an error)
	 *         If an array of numbers is passed as an argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function IMREAL($complexNumber)
	{
		if (is_array($complexNumber)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $complexNumber);
		}

		try {
			$complex = new ComplexObject($complexNumber);
		} catch (ComplexException $exception) {
			return ExcelError::NAN();
		}

		return $complex->getReal();
	}
}

```