Passed
Pull Request — master (#4283)
by Owen
10:53
created

GroupByLimitedTest::testRowBreaks()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 18
Code Lines 15

Duplication

Lines 0
Ratio 0 %

Importance

Changes 2
Bugs 0 Features 0
Metric Value
eloc 15
c 2
b 0
f 0
dl 0
loc 18
rs 9.7666
cc 1
nc 1
nop 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx;
6
7
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
8
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;
9
10
class GroupByLimitedTest extends AbstractFunctional
11
{
12
    private static string $testbook = 'tests/data/Reader/XLSX/excel-groupby-one.xlsx';
13
14
    public function testRowBreaks(): void
15
    {
16
        $reader = new Xlsx();
17
        $spreadsheet = $reader->load(self::$testbook);
18
        $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
19
        $spreadsheet->disconnectWorksheets();
20
        $reloadedSheet = $reloadedSpreadsheet->getActiveSheet();
21
        self::assertSame(['t' => 'array', 'ref' => 'E3:F7'], $reloadedSheet->getCell('E3')->getFormulaAttributes());
22
        $expected = [
23
            ['Design', '$505,000 '],
24
            ['Development', '$346,000 '],
25
            ['Marketing', '$491,000 '],
26
            ['Research', '$573,000 '],
27
            ['Total', '$1,915,000 '],
28
            [null, null],
29
        ];
30
        self::assertSame($expected, $reloadedSheet->rangeToArray('E3:F8'));
31
        $reloadedSpreadsheet->disconnectWorksheets();
32
    }
33
}
34