PhpOffice\PhpSpreadsheetTests\Reader\Gnumeric\DefinedNameTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	fileProvider()	0	5	1
A	testDefinedName()	0	10	1

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Reader\Gnumeric;

use PhpOffice\PhpSpreadsheet\Reader\Gnumeric;
use PHPUnit\Framework\Attributes\DataProvider;
use PHPUnit\Framework\TestCase;

class DefinedNameTest extends TestCase
{
    public static function fileProvider(): array
    {
        return [
            ['tests/data/Reader/Gnumeric/apostrophe3a.gnumeric', 'Sheet1'],
            ['tests/data/Reader/Gnumeric/apostrophe3b.gnumeric', 'Apo\'strophe'],
        ];
    }

    #[DataProvider('fileProvider')]
    public function testDefinedName(string $filename, string $sheetName): void
    {
        $reader = new Gnumeric();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame($sheetName, $sheet->getTitle());
        self::assertSame('=sheet1first', $sheet->getCell('C1')->getValue());
        self::assertSame(1, $sheet->getCell('C1')->getCalculatedValue());
        $spreadsheet->disconnectWorksheets();
    }
}