PhpOffice\PhpSpreadsheetTests\Reader\Xls\Biff8CoverTest::testBiff8Coverage()

Complexity

Conditions	1
Paths	1

Size

Total Lines	25
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function testBiff8Coverage(): void
    {
        $filename = 'tests/data/Reader/XLS/biff8cover.xls';
        $reader = new Xls();
        $spreadsheet = $reader->load($filename);
        $sheet = $spreadsheet->getActiveSheet();
        self::assertSame('=SUM({1;2;3;4;5})', $sheet->getCell('A1')->getValue());
        self::assertSame(15, $sheet->getCell('A1')->getCalculatedValue());
        self::assertSame(
            '=VLOOKUP("hello",'
            . '{"what",1;"why",TRUE;"hello","there";"when",FALSE}'
            . ',2,FALSE)',
            $sheet->getCell('C1')->getValue()
        );
        self::assertSame('there', $sheet->getCell('C1')->getCalculatedValue());
        self::assertSame(2, $sheet->getCell('A3')->getValue());
        self::assertTrue(
            $sheet->getStyle('A3')->getFont()->getSuperscript()
        );
        self::assertSame('n', $sheet->getCell('B3')->getValue());
        self::assertTrue(
            $sheet->getStyle('B3')->getFont()->getSubscript()
        );

        $spreadsheet->disconnectWorksheets();
    }