xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Engineering/IMSEC.php

<?php

use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

return [
    [
        '0.00671973874162309199-0.00154764157870523791j',
        '12.34+5.67j',
    ],
    [
        ExcelError::NAN(),
        'Invalid Complex Number',
    ],
    [
        '-0.153210472299609239-0.0566222314884645297i',
        '3.5+2.5i',
    ],
    [
        '-0.639945455994778845-0.182565069612144926i',
        '3.5+i',
    ],
    [
        '-1.06785504719181066',
        '3.5',
    ],
    [
        '-0.639945455994778845+0.182565069612144926i',
        '3.5-i',
    ],
    [
        '-0.153210472299609239+0.0566222314884645297i',
        '3.5-2.5i',
    ],
    [
        '0.0897986028721219428+0.137981006709970822i',
        '1+2.5i',
    ],
    [
        '0.498337030555186785+0.591083841721045048i',
        '1+i',
    ],
    [
        '1.85081571768092562',
        '1',
    ],
    [
        '0.498337030555186785-0.591083841721045048i',
        '1-i',
    ],
    [
        '0.0897986028721219428-0.137981006709970822i',
        '1-2.5i',
    ],
    [
        '0.163071231929977826',
        '2.5i',
    ],
    [
        '0.648054273663885400',
        'i',
    ],
    [
        '1.0',
        '0',
    ],
    [
        '0.648054273663885400',
        '-i',
    ],
    [
        '0.163071231929977826',
        '-2.5i',
    ],
    [
        '0.0897986028721219428-0.137981006709970822i',
        '-1+2.5i',
    ],
    [
        '0.498337030555186785-0.591083841721045048i',
        '-1+i',
    ],
    [
        '1.85081571768092562',
        '-1',
    ],
    [
        '0.498337030555186785+0.591083841721045048i',
        '-1-i',
    ],
    [
        '0.0897986028721219428+0.137981006709970822i',
        '-1-2.5i',
    ],
    [
        '-0.153210472299609239+0.0566222314884645297i',
        '-3.5+2.5i',
    ],
    [
        '-0.639945455994778845+0.182565069612144926i',
        '-3.5+i',
    ],
    [
        '-1.06785504719181066',
        '-3.5',
    ],
    [
        '-0.639945455994778845-0.182565069612144926i',
        '-3.5-i',
    ],
    [
        '-0.153210472299609239-0.0566222314884645297i',
        '-3.5-2.5i',
    ],
    [
        '-1.01010866590799375',
        '3',
    ],
];