mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-30 20:18:00 +00:00
oleibman
ee7ddf7ca8
These are 5 closely related functions for manipulating arrays. Now that dynamic arrays are part of PhpSpreadsheet, this PR implements those previously-unimplemented functions. Documentation undergoes a very minor change, since they are re-categorized as "Lookup and Reference", which is how Excel classifies them, rather than "Math and Trig".
55 lines
1.5 KiB
PHP
55 lines
1.5 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\LookupRef;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
|
|
use PhpOffice\PhpSpreadsheet\NamedRange;
|
|
use PHPUnit\Framework\Attributes\DataProvider;
|
|
|
|
class ChooseColsTest extends AllSetupTeardown
|
|
{
|
|
#[DataProvider('providerChooseCols')]
|
|
public function testChooseCols(mixed $expectedResult, string $formula): void
|
|
{
|
|
Calculation::setArrayReturnType(
|
|
Calculation::RETURN_ARRAY_AS_ARRAY
|
|
);
|
|
$this->mightHaveException($expectedResult);
|
|
$sheet = $this->getSheet();
|
|
$sheet->fromArray(
|
|
[
|
|
['a', 'b', 'c'],
|
|
['d', 'e', 'f'],
|
|
['g', 'h', 'i'],
|
|
['j', 'k', 'l'],
|
|
['m', 'n', 'o'],
|
|
['p', 'q', 'r'],
|
|
['s', 't', 'u'],
|
|
['v', 'w', 'x'],
|
|
['y', 'z', '#'],
|
|
],
|
|
null,
|
|
'B3',
|
|
true
|
|
);
|
|
$this->getSpreadsheet()->addNamedRange(
|
|
new NamedRange(
|
|
'definedname',
|
|
$sheet,
|
|
'$B$3:$D$11'
|
|
)
|
|
);
|
|
|
|
$sheet->setCellValue('F3', $formula);
|
|
$result = $sheet->getCell('F3')->getCalculatedValue();
|
|
self::assertSame($expectedResult, $result);
|
|
}
|
|
|
|
public static function providerChooseCols(): array
|
|
{
|
|
return require 'tests/data/Calculation/LookupRef/CHOOSECOLS.php';
|
|
}
|
|
}
|