Completed
Branch develop (b42baf)
by Adrien
11:23
created

ReferenceHelperTest::setUp()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 1
c 1
b 0
f 0
nc 1
nop 0
dl 0
loc 3
rs 10
1
<?php
2
3
namespace PhpSpreadsheetTests;
4
5
use PhpSpreadsheet\ReferenceHelper;
6
7
class ReferenceHelperTest extends \PHPUnit_Framework_TestCase
8
{
9
    public function setUp()
10
    {
11
    }
12
13
    public function testColumnSort()
14
    {
15
        $columnBase = $columnExpectedResult = [
16
            'A', 'B', 'Z',
17
            'AA', 'AB', 'AZ',
18
            'BA', 'BB', 'BZ',
19
            'ZA', 'ZB', 'ZZ',
20
            'AAA', 'AAB', 'AAZ',
21
            'ABA', 'ABB', 'ABZ',
22
            'AZA', 'AZB', 'AZZ',
23
            'BAA', 'BAB', 'BAZ',
24
            'BBA', 'BBB', 'BBZ',
25
            'BZA', 'BZB', 'BZZ',
26
        ];
27
        shuffle($columnBase);
28
        usort($columnBase, [ReferenceHelper::class, 'columnSort']);
29
        foreach ($columnBase as $key => $value) {
30
            $this->assertEquals($columnExpectedResult[$key], $value);
31
        }
32
    }
33
34
    public function testColumnReverseSort()
35
    {
36
        $columnBase = $columnExpectedResult = [
37
            'A', 'B', 'Z',
38
            'AA', 'AB', 'AZ',
39
            'BA', 'BB', 'BZ',
40
            'ZA', 'ZB', 'ZZ',
41
            'AAA', 'AAB', 'AAZ',
42
            'ABA', 'ABB', 'ABZ',
43
            'AZA', 'AZB', 'AZZ',
44
            'BAA', 'BAB', 'BAZ',
45
            'BBA', 'BBB', 'BBZ',
46
            'BZA', 'BZB', 'BZZ',
47
        ];
48
        shuffle($columnBase);
49
        $columnExpectedResult = array_reverse($columnExpectedResult);
50
        usort($columnBase, [ReferenceHelper::class, 'columnReverseSort']);
51
        foreach ($columnBase as $key => $value) {
52
            $this->assertEquals($columnExpectedResult[$key], $value);
53
        }
54
    }
55
}
56