PhpSpreadsheet/tests/PhpSpreadsheetTests/Reader/Xls/Issue4356Test.php

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Reader\Xls;

use PhpOffice\PhpSpreadsheet\NamedRange;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;

class Issue4356Test extends AbstractFunctional
{
    public function testIssue4356(): void
    {
        // Reader couldn't handle sheet title with apostrophe for defined name.
        // Issue was reported against Xlsx - see how Xls does.
        $nameDefined = 'CELLNAME';
        $originalSpreadsheet = new Spreadsheet();
        $originalSheet = $originalSpreadsheet->getActiveSheet();
        $originalSheet->setTitle("Goodn't sheet name");
        $originalSpreadsheet->addNamedRange(
            new NamedRange($nameDefined, $originalSheet, '$A$1')
        );
        $originalSheet->setCellValue('A1', 'This is a named cell.');
        $originalSheet->getStyle($nameDefined)
            ->getFont()
            ->setItalic(true);
        $spreadsheet = $this->writeAndReload($originalSpreadsheet, 'Xls');
        $originalSpreadsheet->disconnectWorksheets();

        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('C1', "=$nameDefined");
        self::assertSame('This is a named cell.', $sheet->getCell('C1')->getCalculatedValue());
        $namedRange2 = $spreadsheet->getNamedRange($nameDefined);
        self::assertNotNull($namedRange2);
        $sheetx = $namedRange2->getWorksheet();
        self::assertNotNull($sheetx);
        $style = $sheetx->getStyle($nameDefined);
        self::assertTrue($style->getFont()->getItalic());
        $style->getFont()->setItalic(false);

        $spreadsheet->disconnectWorksheets();
    }
}