BesselKTest.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  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 PHPUnit\Framework\TestCase;
  7. class BesselKTest extends TestCase
  8. {
  9. const BESSEL_PRECISION = 1E-12;
  10. protected function setUp(): void
  11. {
  12. Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
  13. }
  14. /**
  15. * @dataProvider providerBESSELK
  16. *
  17. * @param mixed $expectedResult
  18. */
  19. public function testBESSELK($expectedResult, ...$args): void
  20. {
  21. $result = Engineering::BESSELK(...$args);
  22. self::assertEqualsWithDelta($expectedResult, $result, self::BESSEL_PRECISION);
  23. }
  24. public function providerBESSELK(): array
  25. {
  26. return require 'tests/data/Calculation/Engineering/BESSELK.php';
  27. }
  28. /**
  29. * @dataProvider providerBesselKArray
  30. */
  31. public function testBesselKArray(array $expectedResult, string $value, string $ord): void
  32. {
  33. $calculation = Calculation::getInstance();
  34. $formula = "=BESSELK({$value}, {$ord})";
  35. $result = $calculation->_calculateFormulaValue($formula);
  36. self::assertEqualsWithDelta($expectedResult, $result, 1.0e-14);
  37. }
  38. public function providerBesselKArray(): array
  39. {
  40. return [
  41. 'row/column vector' => [
  42. [
  43. [4.721244734980139, 1.5415067364690132, 0.9244190350213235, 0.2976030874538336, 0.06234755419101918],
  44. [99.97389411857176, 3.747025980669556, 1.6564411280110791, 0.4021240820149834, 0.07389081565026694],
  45. [19999.500068449335, 31.517714581825462, 7.5501835470656395, 0.9410016186778072, 0.12146020671123273],
  46. ],
  47. '{0.01, 0.25, 0.5, 1.25, 2.5}',
  48. '{0; 1; 2}',
  49. ],
  50. ];
  51. }
  52. }