PhpOffice\PhpSpreadsheetTests\Writer\Xls\HyperlinkTest

Complexity

Total Complexity

1

Size/Duplication

Total Lines	27
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	testHyperlink()	0	25	1

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Xls;

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

class HyperlinkTest extends AbstractFunctional
{
    public function testHyperlink(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet1 = $spreadsheet->getActiveSheet();
        $sheet1->setTitle('First');
        $sheet2 = $spreadsheet->createSheet();
        $sheet2->setTitle('Second');
        $sheet2->setCellValue('A100', 'other sheet');
        $sheet1->setCellValue('A100', 'this sheet');
        $sheet1->setCellValue('A1', '=HYPERLINK("#A100", "here")');
        $sheet1->setCellValue('A2', '=HYPERLINK("#Second!A100", "there")');
        $sheet1->setCellValue('A3', '=HYPERLINK("http://example.com", "external")');
        $sheet1->setCellValue('A4', 'gotoA101');
        $sheet1->getCell('A4')
            ->getHyperlink()
            ->setUrl('#A101');

        $robj = $this->writeAndReload($spreadsheet, 'Xls');
        $spreadsheet->disconnectWorksheets();
        $sheet0 = $robj->setActiveSheetIndex(0);
        self::assertSame('sheet://#A100', $sheet0->getCell('A1')->getHyperlink()->getUrl());
        self::assertSame('sheet://#Second!A100', $sheet0->getCell('A2')->getHyperlink()->getUrl());
        self::assertSame('http://example.com', $sheet0->getCell('A3')->getHyperlink()->getUrl());
        self::assertSame('sheet://#A101', $sheet0->getCell('A4')->getHyperlink()->getUrl());
        $robj->disconnectWorksheets();
    }
}