mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-27 18:48:36 +00:00
26079174a0
* Implementation of the SEQUENCE() Excel365 function Note that the Calculation Engine does not yet support the Spill operator, or spilling functions * Handle the use-case of step = 0; and tests for exception handling for invalid arguments * Update Change Log
26 lines
658 B
PHP
26 lines
658 B
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\MathTrig;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\MathTrig;
|
|
|
|
class SequenceTest extends AllSetupTeardown
|
|
{
|
|
/**
|
|
* @dataProvider providerSEQUENCE
|
|
*
|
|
* @param mixed[] $arguments
|
|
* @param mixed[]|string $expectedResult
|
|
*/
|
|
public function testSEQUENCE(array $arguments, $expectedResult): void
|
|
{
|
|
$result = MathTrig\MatrixFunctions::sequence(...$arguments);
|
|
self::assertEquals($expectedResult, $result);
|
|
}
|
|
|
|
public function providerSEQUENCE(): array
|
|
{
|
|
return require 'tests/data/Calculation/MathTrig/SEQUENCE.php';
|
|
}
|
|
}
|