Completed
Push — develop ( c72383...7e9f43 )
by Adrien
40:14
created

CommentsTest::testComments()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 17
Code Lines 11

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 11
nc 1
nop 1
dl 0
loc 17
rs 9.4285
c 0
b 0
f 0
1
<?php
2
3
namespace PhpOffice\PhpSpreadsheetTests\Functional;
4
5
use PhpOffice\PhpSpreadsheet\Spreadsheet;
6
7
class CommentsTest extends AbstractFunctional
8
{
9
    public function providerFormats()
10
    {
11
        return [
12
            ['Html'],
13
            ['Xlsx'],
14
            ['Ods'],
15
        ];
16
    }
17
18
    /**
19
     * Test load file with comment in sheet to load proper
20
     * count of comments in correct coords.
21
     *
22
     * @dataProvider providerFormats
23
     *
24
     * @param $format
25
     */
26
    public function testComments($format)
27
    {
28
        $spreadsheet = new Spreadsheet();
29
30
        $spreadsheet->getActiveSheet()->getCell('E10')->setValue('Comment');
31
        $spreadsheet->getActiveSheet()
32
            ->getComment('E10')
33
            ->getText()
34
            ->createText('Comment to test');
35
36
        $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, $format);
37
38
        $commentsLoaded = $reloadedSpreadsheet->getSheet(0)->getComments();
39
        self::assertCount(1, $commentsLoaded);
40
41
        $commentCoordinate = key($commentsLoaded);
42
        self::assertSame('E10', $commentCoordinate);
43
    }
44
}
45