| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <?php
- namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Engineering;
- use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
- use PhpOffice\PhpSpreadsheet\Calculation\Engineering;
- use PhpOffice\PhpSpreadsheet\Calculation\Functions;
- use PhpOffice\PhpSpreadsheetTests\Custom\ComplexAssert;
- use PHPUnit\Framework\TestCase;
- class ImLnTest extends TestCase
- {
- const COMPLEX_PRECISION = 1E-8;
- /**
- * @var ComplexAssert
- */
- private $complexAssert;
- protected function setUp(): void
- {
- Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
- $this->complexAssert = new ComplexAssert();
- }
- /**
- * @dataProvider providerIMLN
- *
- * @param mixed $expectedResult
- * @param mixed $value
- */
- public function testIMLN($expectedResult, $value): void
- {
- $result = Engineering::IMLN($value);
- self::assertTrue(
- $this->complexAssert->assertComplexEquals($expectedResult, $result, self::COMPLEX_PRECISION),
- $this->complexAssert->getErrorMessage()
- );
- }
- public function providerIMLN(): array
- {
- return require 'tests/data/Calculation/Engineering/IMLN.php';
- }
- /**
- * @dataProvider providerImLnArray
- */
- public function testImLnArray(array $expectedResult, string $complex): void
- {
- $calculation = Calculation::getInstance();
- $formula = "=IMLN({$complex})";
- $result = $calculation->_calculateFormulaValue($formula);
- self::assertEquals($expectedResult, $result);
- }
- public function providerImLnArray(): array
- {
- return [
- 'row/column vector' => [
- [
- ['0.99050073443329-1.9513027039073i', '0.91629073187416-1.5707963267949i', '0.99050073443329-1.1902899496825i'],
- ['0.34657359027997-2.3561944901923i', '-1.5707963267949i', '0.34657359027997-0.78539816339745i'],
- ['0.34657359027997+2.3561944901923i', '1.5707963267949i', '0.34657359027997+0.78539816339745i'],
- ['0.99050073443329+1.9513027039073i', '0.91629073187416+1.5707963267949i', '0.99050073443329+1.1902899496825i'],
- ],
- '{"-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"}',
- ],
- ];
- }
- }
|