ImLnTest.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 ImLnTest 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 providerIMLN
  22. *
  23. * @param mixed $expectedResult
  24. * @param mixed $value
  25. */
  26. public function testIMLN($expectedResult, $value): void
  27. {
  28. $result = Engineering::IMLN($value);
  29. self::assertTrue(
  30. $this->complexAssert->assertComplexEquals($expectedResult, $result, self::COMPLEX_PRECISION),
  31. $this->complexAssert->getErrorMessage()
  32. );
  33. }
  34. public function providerIMLN(): array
  35. {
  36. return require 'tests/data/Calculation/Engineering/IMLN.php';
  37. }
  38. /**
  39. * @dataProvider providerImLnArray
  40. */
  41. public function testImLnArray(array $expectedResult, string $complex): void
  42. {
  43. $calculation = Calculation::getInstance();
  44. $formula = "=IMLN({$complex})";
  45. $result = $calculation->_calculateFormulaValue($formula);
  46. self::assertEquals($expectedResult, $result);
  47. }
  48. public function providerImLnArray(): array
  49. {
  50. return [
  51. 'row/column vector' => [
  52. [
  53. ['0.99050073443329-1.9513027039073i', '0.91629073187416-1.5707963267949i', '0.99050073443329-1.1902899496825i'],
  54. ['0.34657359027997-2.3561944901923i', '-1.5707963267949i', '0.34657359027997-0.78539816339745i'],
  55. ['0.34657359027997+2.3561944901923i', '1.5707963267949i', '0.34657359027997+0.78539816339745i'],
  56. ['0.99050073443329+1.9513027039073i', '0.91629073187416+1.5707963267949i', '0.99050073443329+1.1902899496825i'],
  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. }