PHP Decode

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx;

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Style\Conditional;
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;

class ConditionalTest extends AbstractFunctional
{
    public function testLoadingConditionalDoesntLoseSelectedCell(): void
    {
        $filename = 'tests/data/Reader/XLSX/ConditionalFormat_Ranges.xlsx';
        $reader = IOFactory::createReader('Xlsx');
        $spreadsheet = $reader->load($filename);
        $worksheet = $spreadsheet->getActiveSheet();

        self::assertSame('A1', $worksheet->getActiveCell());
        self::assertSame('A1', $worksheet->getSelectedCells());
    }

    /**
     * Test check if conditional style with type 'notContainsText' works on xlsx.
     */
    public function testConditionalNotContainsText(): void
    {
        $filename = 'tests/data/Reader/XLSX/conditionalFormatting3Test.xlsx';
        $reader = IOFactory::createReader('Xlsx');
        $spreadsheet = $reader->load($filename);
        $worksheet = $spreadsheet->getActiveSheet();
        $styles = $worksheet->getConditionalStyles('A1:A5');

        self::assertCount(1, $styles);

        /** @var Conditional $notContainsTextStyle */
        $notContainsTextStyle = $styles[0];
        self::assertEquals('A', $notContainsTextStyle->getText());
        self::assertEquals(Conditional::CONDITION_NOTCONTAINSTEXT, $notContainsTextStyle->getConditionType());
        self::assertEquals(Conditional::OPERATOR_NOTCONTAINS, $notContainsTextStyle->getOperatorType());
    }
}
 ?>