LcmTest.php 772 B

1234567891011121314151617181920212223242526272829
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\MathTrig;
  3. class LcmTest extends AllSetupTeardown
  4. {
  5. /**
  6. * @dataProvider providerLCM
  7. *
  8. * @param mixed $expectedResult
  9. */
  10. public function testLCM($expectedResult, ...$args): void
  11. {
  12. $sheet = $this->getSheet();
  13. $row = 0;
  14. foreach ($args as $arg) {
  15. ++$row;
  16. $sheet->getCell("A$row")->setValue($arg);
  17. }
  18. $sheet->getCell('B1')->setValue("=LCM(A1:A$row)");
  19. $result = $sheet->getCell('B1')->getCalculatedValue();
  20. self::assertEqualsWithDelta($expectedResult, $result, 1E-12);
  21. }
  22. public function providerLCM(): array
  23. {
  24. return require 'tests/data/Calculation/MathTrig/LCM.php';
  25. }
  26. }