ImCosTest.php 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Engineering;
  3. use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
  4. use PhpOffice\PhpSpreadsheet\Calculation\Engineering;
  5. use PhpOffice\PhpSpreadsheet\Calculation\Functions;
  6. use PhpOffice\PhpSpreadsheetTests\Custom\ComplexAssert;
  7. use PHPUnit\Framework\TestCase;
  8. class ImCosTest extends TestCase
  9. {
  10. const COMPLEX_PRECISION = 1E-8;
  11. /**
  12. * @var ComplexAssert
  13. */
  14. private $complexAssert;
  15. protected function setUp(): void
  16. {
  17. Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
  18. $this->complexAssert = new ComplexAssert();
  19. }
  20. /**
  21. * @dataProvider providerIMCOS
  22. *
  23. * @param mixed $expectedResult
  24. * @param mixed $value
  25. */
  26. public function testIMCOS($expectedResult, $value): void
  27. {
  28. $result = Engineering::IMCOS($value);
  29. self::assertTrue(
  30. $this->complexAssert->assertComplexEquals($expectedResult, $result, self::COMPLEX_PRECISION),
  31. $this->complexAssert->getErrorMessage()
  32. );
  33. }
  34. public function providerIMCOS(): array
  35. {
  36. return require 'tests/data/Calculation/Engineering/IMCOS.php';
  37. }
  38. /**
  39. * @dataProvider providerImCosArray
  40. */
  41. public function testImCosArray(array $expectedResult, string $complex): void
  42. {
  43. $calculation = Calculation::getInstance();
  44. $formula = "=IMCOS({$complex})";
  45. $result = $calculation->_calculateFormulaValue($formula);
  46. self::assertEquals($expectedResult, $result);
  47. }
  48. public function providerImCosArray(): array
  49. {
  50. return [
  51. 'row/column vector' => [
  52. [
  53. ['3.3132901461132-5.0910715229497i', 6.1322894796637, '3.3132901461132+5.0910715229497i'],
  54. ['0.83373002513115-0.98889770576287i', 1.5430806348152, '0.83373002513115+0.98889770576287i'],
  55. ['0.83373002513115+0.98889770576287i', 1.5430806348152, '0.83373002513115-0.98889770576287i'],
  56. ['3.3132901461132+5.0910715229497i', 6.1322894796637, '3.3132901461132-5.0910715229497i'],
  57. ],
  58. '{"-1-2.5i", "-2.5i", "1-2.5i"; "-1-i", "-i", "1-i"; "-1+i", "i", "1+1"; "-1+2.5i", "+2.5i", "1+2.5i"}',
  59. ],
  60. ];
  61. }
  62. }