PhpOffice\PhpSpreadsheetTests\Calculation\Functions\LookupRef\TransposeOnSpreadsheetTest::testTRANSPOSE()

Complexity

Conditions	2
Paths	2

Size

Total Lines	16
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    #[DataProvider('providerTRANSPOSE')]
    public function testTRANSPOSE(mixed $expectedResult, mixed $matrix): void
    {
        $sheet = $this->getSheet();
        $this->setArrayAsArray();
        if (!is_array($matrix)) {
            $matrix = [$matrix];
        }
        $sheet->fromArray($matrix, null, 'A1', true);
        $highColumn = $sheet->getHighestDataColumn();
        $highRow = $sheet->getHighestDataRow();
        $newHighColumn = $highColumn;
        ++$newHighColumn;
        $sheet->getCell("{$newHighColumn}1")
            ->setValue("=TRANSPOSE(A1:$highColumn$highRow)");
        self::assertSame($expectedResult, $sheet->getCell("{$newHighColumn}1")->getCalculatedValue());
    }