alex
/
PhpSpreadsheet
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
PhpSpreadsheet/tests/data/Calculation/Engineering/IMCSCH.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 [
[
'7.15308425027293823E-6+5.03341614148979354E-6j',
'12.34+5.67j',
],
[
'-0.0483657415388563464-0.0361962406084861128i',
'3.5+2.5i',
],
[
'0.0325769243120443503-0.0508281676948511387i',
'3.5+i',
],
[
'0.0604498900091561051',
'3.5',
],
[
'0.0325769243120443503+0.0508281676948511387i',
'3.5-i',
],
[
'-0.0483657415388563464+0.0361962406084861128i',
'3.5-2.5i',
],
[
'-0.541322906190002332-0.530965577621174208i',
'1+2.5i',
],
[
'0.303931001628426450-0.621518017170428421i',
'1+i',
],
[
'0.850918128239321545',
'1',
],
[
'0.303931001628426450+0.621518017170428421i',
'1-i',
],
[
'-0.541322906190002332+0.530965577621174208i',
'1-2.5i',
],
[
'-1.67092154555867993i',
'2.5i',
],
[
'-1.18839510577812122i',
'i',
],
[
INF,
'0',
],
[
'1.18839510577812122i',
'-i',
],
[
'1.67092154555868i',
'-2.5i',
],
[
'0.5413229061900022-0.5309655776211742i',
'-1+2.5i',
],
[
'-0.30393100162842645-0.62151801717042842i',
'-1+i',
],
[
'-0.850918128239321545',
'-1',
],
[
'-0.30393100162842645+0.62151801717042842i',
'-1-i',
],
[
'0.5413229061900022+0.5309655776211742i',
'-1-2.5i',
],
[
'0.04836574153885635-0.03619624060848612i',
'-3.5+2.5i',
],
[
'-0.03257692431204435-0.05082816769485113i',
'-3.5+i',
],
[
'-0.0604498900091561051',
'-3.5',
],
[
'-0.03257692431204435+0.05082816769485113i',
'-3.5-i',
],
[
'0.04836574153885635+0.03619624060848612i',
'-3.5-2.5i',
],
[
'0.0998215696688227329',
'3',
],
];