PhpOffice\PhpSpreadsheetTests\Reader\Xlsx\Issue4356Test::testIssue4356()

Complexity

Conditions	1
Paths	1

Size

Total Lines	18
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function testIssue4356(): void
    {
        // Reader couldn't handle sheet title with apostrophe for defined name
        $originalSpreadsheet = new Spreadsheet();
        $originalSheet = $originalSpreadsheet->getActiveSheet();
        $originalSheet->setTitle("Goodn't sheet name");
        $originalSpreadsheet->addNamedRange(
            new NamedRange('CELLNAME', $originalSheet, '$A$1')
        );
        $originalSheet->setCellValue('A1', 'This is a named cell.');
        $spreadsheet = $this->writeAndReload($originalSpreadsheet, 'Xlsx');
        $originalSpreadsheet->disconnectWorksheets();

        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('C1', '=CELLNAME');
        self::assertSame('This is a named cell.', $sheet->getCell('C1')->getCalculatedValue());

        $spreadsheet->disconnectWorksheets();
    }