alex
/
PhpSpreadsheet
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
PhpSpreadsheet/tests/data/Calculation/Engineering/IMCSC.php

113 lines
2.0 KiB
PHP
Raw Permalink Normal View History

Add new Complex Number Functions introduced in MS Excel 2013 (#601) * - Refactored Complex Engineering Functions to use external complex number library - Added calculation engine support for the new complex number functions that were added in MS Excel 2013 - IMCOSH() Returns the hyperbolic cosine of a complex number - IMCOT() Returns the cotangent of a complex number - IMCSC() Returns the cosecant of a complex number - IMCSCH() Returns the hyperbolic cosecant of a complex number - IMSEC() Returns the secant of a complex number - IMSECH() Returns the hyperbolic secant of a complex number - IMSINH() Returns the hyperbolic sine of a complex number - IMTAN() Returns the tangent of a complex number * Simplified the parseComplex() method in the PhpOffice\PhpSpreadsheet\Calculation\Engineering class, using Complex\Complex; and docblock flagged as deprecated
2018-07-25 13:38:44 +00:00
<?php
return [
[
'-0.00154774455592154432-0.00671986631601416928j',
'12.34+5.67j',
],
[
'-0.0585684747824233590+0.154262439469903774i',
'3.5+2.5i',
],
[
'-0.359863036667298479+0.731660683934045561i',
'3.5+i',
],
[
'-2.85076343754046413',
'3.5',
],
[
'-0.359863036667298479-0.731660683934045561i',
'3.5-i',
],
[
'-0.0585684747824233590-0.154262439469903774i',
'3.5-2.5i',
],
[
'0.138293277776215018-0.0876084810883255787i',
'1+2.5i',
],
[
'0.621518017170428421-0.303931001628426450i',
'1+i',
],
[
'1.18839510577812122',
'1',
],
[
'0.621518017170428421+0.303931001628426450i',
'1-i',
],
[
'0.138293277776215018+0.0876084810883255787i',
'1-2.5i',
],
[
'-0.165283669855095565i',
'2.5i',
],
[
'-0.850918128239321545i',
'i',
],
[
INF,
'0',
],
[
'0.850918128239321545i',
'-i',
],
[
'0.1652836698550956i',
'-2.5i',
],
[
'-0.138293277776215-0.0876084810883256i',
'-1+2.5i',
],
[
'-0.62151801717042842-0.30393100162842645i',
'-1+i',
],
[
'-1.18839510577812122',
'-1',
],
[
'-0.62151801717042842+0.30393100162842645i',
'-1-i',
],
[
'-0.138293277776215+0.0876084810883256i',
'-1-2.5i',
],
[
'0.05856847478242335+0.1542624394699038i',
'-3.5+2.5i',
],
[
'0.3598630366672985+0.7316606839340456i',
'-3.5+i',
],
[
'2.85076343754046413',
'-3.5',
],
[
'0.3598630366672985-0.7316606839340456i',
'-3.5-i',
],
[
'0.05856847478242335-0.1542624394699038i',
'-3.5-2.5i',
],
[
'7.08616739573718592',
'3',
],
];