Completed
Push — develop ( 685e29...09d456 )
by Adrien
14:14
created
tests/PhpSpreadsheet/Worksheet/AutoFilter/ColumnTest.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -113,7 +113,7 @@  discard block
 block discarded – undo
113 113
     {
114 114
         $attributeSet = ['val' => 100,
115 115
                                 'maxVal' => 200,
116
-                             ];
116
+                                ];
117 117
 
118 118
         //    Setters return the instance to implement the fluent interface
119 119
         $result = $this->testAutoFilterColumnObject->setAttributes($attributeSet);
@@ -124,7 +124,7 @@  discard block
 block discarded – undo
124 124
     {
125 125
         $attributeSet = ['val' => 100,
126 126
                                 'maxVal' => 200,
127
-                             ];
127
+                                ];
128 128
 
129 129
         $this->testAutoFilterColumnObject->setAttributes($attributeSet);
130 130
 
@@ -137,7 +137,7 @@  discard block
 block discarded – undo
137 137
     {
138 138
         $attributeSet = ['val' => 100,
139 139
                                 'maxVal' => 200,
140
-                             ];
140
+                                ];
141 141
 
142 142
         foreach ($attributeSet as $attributeName => $attributeValue) {
143 143
             //    Setters return the instance to implement the fluent interface
@@ -150,7 +150,7 @@  discard block
 block discarded – undo
150 150
     {
151 151
         $attributeSet = ['val' => 100,
152 152
                                 'maxVal' => 200,
153
-                             ];
153
+                                ];
154 154
 
155 155
         $this->testAutoFilterColumnObject->setAttributes($attributeSet);
156 156
 
Please login to merge, or discard this patch.
tests/data/Shared/Date/TimestampToExcel1900.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -2,15 +2,15 @@
 block discarded – undo
2 2
 
3 3
 // Unix TimeStamp   Result           Comments
4 4
 return [
5
-    [-2147472000,  714],    //  PHP 32-bit Earliest Date        14-Dec-1901
6
-    [-2082931200,  1461],    //                                  31-Dec-1903
7
-    [-2082844800,  1462],    //  Excel 1904 Calendar Base Date   01-Jan-1904
8
-    [-2082758400,  1463],    //                                  02-Jan-1904
9
-    [-285120000,   22269],    //                                  19-Dec-1960
10
-    [0,            25569],    //  PHP Base Date                   01-Jan-1970
11
-    [408067200,    30292],    //                                  07-Dec-1982
12
-    [1213228800,   39611],    //                                  12-Jun-2008
13
-    [2147472000,   50424],    //  PHP 32-bit Latest Date          19-Jan-2038
14
-    [-2102494934,  1234.56789],    //                                  18-May-1903 13:37:46
15
-    [-1142494943,  12345.6789],    //                                  18-Oct-1933 16:17:37
5
+    [-2147472000, 714], //  PHP 32-bit Earliest Date        14-Dec-1901
6
+    [-2082931200, 1461], //                                  31-Dec-1903
7
+    [-2082844800, 1462], //  Excel 1904 Calendar Base Date   01-Jan-1904
8
+    [-2082758400, 1463], //                                  02-Jan-1904
9
+    [-285120000, 22269], //                                  19-Dec-1960
10
+    [0, 25569], //  PHP Base Date                   01-Jan-1970
11
+    [408067200, 30292], //                                  07-Dec-1982
12
+    [1213228800, 39611], //                                  12-Jun-2008
13
+    [2147472000, 50424], //  PHP 32-bit Latest Date          19-Jan-2038
14
+    [-2102494934, 1234.56789], //                                  18-May-1903 13:37:46
15
+    [-1142494943, 12345.6789], //                                  18-Oct-1933 16:17:37
16 16
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/FormattedPHPToExcel1900.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -2,15 +2,15 @@
 block discarded – undo
2 2
 
3 3
 //    Year   Month  Day  Hours  Minutes  Seconds  Result            Comments
4 4
 return [
5
-    [1901,  12,    14,                           714],    //    PHP 32-bit Earliest Date        14-Dec-1901
6
-    [1903,  12,    31,                           1461],    //                                    31-Dec-1903
7
-    [1904,  1,     1,                            1462],    //    Excel 1904 Calendar Base Date   01-Jan-1904
8
-    [1904,  1,     2,                            1463],    //                                    02-Jan-1904
9
-    [1960,  12,    19,                           22269],    //                                    19-Dec-1960
10
-    [1970,  1,     1,                            25569],    //    PHP Base Date                   01-Jan-1970
11
-    [1982,  12,    7,                            30292],    //                                    07-Dec-1982
12
-    [2008,  6,     12,                           39611],    //                                    12-Jun-2008
13
-    [2038,  1,     19,                           50424],    //    PHP 32-bit Latest Date          19-Jan-2038
14
-    [1903,  5,     18,  13,    37,      46,      1234.56789],    //                                    18-May-1903 13:37:46
15
-    [1933,  10,    18,  16,    17,      37,      12345.6789],    //                                    18-Oct-1933 16:17:37
5
+    [1901, 12, 14, 714], //    PHP 32-bit Earliest Date        14-Dec-1901
6
+    [1903, 12, 31, 1461], //                                    31-Dec-1903
7
+    [1904, 1, 1, 1462], //    Excel 1904 Calendar Base Date   01-Jan-1904
8
+    [1904, 1, 2, 1463], //                                    02-Jan-1904
9
+    [1960, 12, 19, 22269], //                                    19-Dec-1960
10
+    [1970, 1, 1, 25569], //    PHP Base Date                   01-Jan-1970
11
+    [1982, 12, 7, 30292], //                                    07-Dec-1982
12
+    [2008, 6, 12, 39611], //                                    12-Jun-2008
13
+    [2038, 1, 19, 50424], //    PHP 32-bit Latest Date          19-Jan-2038
14
+    [1903, 5, 18, 13, 37, 46, 1234.56789], //                                    18-May-1903 13:37:46
15
+    [1933, 10, 18, 16, 17, 37, 12345.6789], //                                    18-Oct-1933 16:17:37
16 16
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/DateTimeToExcel.php 1 patch
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -2,19 +2,19 @@
 block discarded – undo
2 2
 
3 3
 // DateTime object                          Result           Comments
4 4
 return [
5
-    [new DateTime('1900-01-01'),           1.0],    //  Excel 1900 base calendar date
6
-    [new DateTime('1900-02-28'),           59.0],    //  This and next test show gap for the mythical
7
-    [new DateTime('1900-03-01'),           61.0],    //      MS Excel 1900 Leap Year
8
-    [new DateTime('1901-12-14'),           714.0],    //  Unix Timestamp 32-bit Earliest Date
9
-    [new DateTime('1903-12-31'),           1461.0],
10
-    [new DateTime('1904-01-01'),           1462.0],    //  Excel 1904 Calendar Base Date
11
-    [new DateTime('1904-01-02'),           1463.0],
12
-    [new DateTime('1960-12-19'),           22269.0],
13
-    [new DateTime('1970-01-01'),           25569.0],    //  Unix Timestamp Base Date
14
-    [new DateTime('1982-12-07'),           30292.0],
15
-    [new DateTime('2008-06-12'),           39611.0],
16
-    [new DateTime('2038-01-19'),           50424.0],    //  Unix Timestamp 32-bit Latest Date
17
-    [new DateTime('1903-05-18 13:37:46'),  1234.56789],
18
-    [new DateTime('1933-10-18 16:17:37'),  12345.6789],
19
-    [new DateTime('2099-12-31'),           73050.0],
5
+    [new DateTime('1900-01-01'), 1.0], //  Excel 1900 base calendar date
6
+    [new DateTime('1900-02-28'), 59.0], //  This and next test show gap for the mythical
7
+    [new DateTime('1900-03-01'), 61.0], //      MS Excel 1900 Leap Year
8
+    [new DateTime('1901-12-14'), 714.0], //  Unix Timestamp 32-bit Earliest Date
9
+    [new DateTime('1903-12-31'), 1461.0],
10
+    [new DateTime('1904-01-01'), 1462.0], //  Excel 1904 Calendar Base Date
11
+    [new DateTime('1904-01-02'), 1463.0],
12
+    [new DateTime('1960-12-19'), 22269.0],
13
+    [new DateTime('1970-01-01'), 25569.0], //  Unix Timestamp Base Date
14
+    [new DateTime('1982-12-07'), 30292.0],
15
+    [new DateTime('2008-06-12'), 39611.0],
16
+    [new DateTime('2038-01-19'), 50424.0], //  Unix Timestamp 32-bit Latest Date
17
+    [new DateTime('1903-05-18 13:37:46'), 1234.56789],
18
+    [new DateTime('1933-10-18 16:17:37'), 12345.6789],
19
+    [new DateTime('2099-12-31'), 73050.0],
20 20
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/FormatCodes.php 1 patch
Spacing   +36 added lines, -36 removed lines patch added patch discarded remove patch
@@ -2,40 +2,40 @@
 block discarded – undo
2 2
 
3 3
 //  Excel Format Code                     Result
4 4
 return [
5
-    ['General',                          false],
6
-    ['@',                                false],
7
-    ['0',                                false],
8
-    ['0.00',                             false],
9
-    ['#,##0.00',                         false],
10
-    ['#,##0.00_-',                       false],
11
-    ['0%',                               false],
12
-    ['0.00%',                            false],
13
-    ['yyyy-mm-dd',                       true],
14
-    ['yy-mm-dd',                         true],
15
-    ['dd/mm/yy',                         true],
16
-    ['d/m/y',                            true],
17
-    ['d-m-y',                            true],
18
-    ['d-m',                              true],
19
-    ['m-y',                              true],
20
-    ['mm-dd-yy',                         true],
21
-    ['d-mmm-yy',                         true],
22
-    ['d-mmm',                            true],
23
-    ['mmm-yy',                           true],
24
-    ['m/d/yy h:mm',                      true],
25
-    ['d/m/y h:mm',                       true],
26
-    ['h:mm AM/PM',                       true],
27
-    ['h:mm:ss AM/PM',                    true],
28
-    ['h:mm',                             true],
29
-    ['h:mm:ss',                          true],
30
-    ['mm:ss',                            true],
31
-    ['h:mm:ss',                          true],
32
-    ['i:s.S',                            true],
33
-    ['h:mm:ss;@',                        true],
34
-    ['yy/mm/dd;@',                       true],
35
-    ['"$" #,##0.00_-',                   false],
36
-    ['$#,##0_-',                         false],
37
-    ['[$EUR ]#,##0.00_-',                false],
38
-    ['_[$EUR ]#,##0.00_-',               false],
39
-    ['[Green]#,##0.00;[Red]#,##0.00_-',  false],
40
-    ['#,##0.00 "dollars"',               false],
5
+    ['General', false],
6
+    ['@', false],
7
+    ['0', false],
8
+    ['0.00', false],
9
+    ['#,##0.00', false],
10
+    ['#,##0.00_-', false],
11
+    ['0%', false],
12
+    ['0.00%', false],
13
+    ['yyyy-mm-dd', true],
14
+    ['yy-mm-dd', true],
15
+    ['dd/mm/yy', true],
16
+    ['d/m/y', true],
17
+    ['d-m-y', true],
18
+    ['d-m', true],
19
+    ['m-y', true],
20
+    ['mm-dd-yy', true],
21
+    ['d-mmm-yy', true],
22
+    ['d-mmm', true],
23
+    ['mmm-yy', true],
24
+    ['m/d/yy h:mm', true],
25
+    ['d/m/y h:mm', true],
26
+    ['h:mm AM/PM', true],
27
+    ['h:mm:ss AM/PM', true],
28
+    ['h:mm', true],
29
+    ['h:mm:ss', true],
30
+    ['mm:ss', true],
31
+    ['h:mm:ss', true],
32
+    ['i:s.S', true],
33
+    ['h:mm:ss;@', true],
34
+    ['yy/mm/dd;@', true],
35
+    ['"$" #,##0.00_-', false],
36
+    ['$#,##0_-', false],
37
+    ['[$EUR ]#,##0.00_-', false],
38
+    ['_[$EUR ]#,##0.00_-', false],
39
+    ['[Green]#,##0.00;[Red]#,##0.00_-', false],
40
+    ['#,##0.00 "dollars"', false],
41 41
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/ExcelToTimestamp1900Timezone.php 1 patch
Spacing   +22 added lines, -22 removed lines patch added patch discarded remove patch
@@ -2,26 +2,26 @@
 block discarded – undo
2 2
 
3 3
 // Excel DateTimeStamp  Timezone               Result            Comments
4 4
 return [
5
-    [22269,            'America/New_York',    -285102000],    //    19-Dec-1960 00:00:00 EST => 19-Dec-1960 05:00:00 UTC
6
-    [25569,            'America/New_York',    18000],    //    01-Jan-1970 00:00:00 EST => 01-Jan-1970 05:00:00 UTC    PHP Base Date
7
-    [30292,            'America/New_York',    408085200],    //    07-Dec-1982 00:00:00 EST => 07-Dec-1982 05:00:00 UTC
8
-    [39611,            'America/New_York',    1213243200],    //    12-Jun-2008 00:00:00 EDT => 12-Jun-2008 04:00:00 UTC
9
-    [50424,            'America/New_York',    2147490000],    //    19-Jan-2038 00:00:00 EST => 19-Jan-2038 05:00:00 UTC    PHP 32-bit Latest Date
10
-    [22345.56789,      'America/New_York',    -278486534],    //    05-Mar-1961 13:37:46 EST => 05-Mar-1961 18:37:46 UTC
11
-    [22345.6789,       'America/New_York',    -278476943],    //    05-Mar-1961 16:17:37 EST => 05-Mar-1961 21:17:37 UTC
12
-    [0.5,              'America/New_York',    61200],    //    12:00:00 EST => 17:00:00 UTC
13
-    [0.75,             'America/New_York',    82800],    //    18:00.00 EST => 23:00:00 UTC
14
-    [0.12345,          'America/New_York',    28666],    //    02:57:46 EST => 07:57:46 UTC
15
-    [41215,            'America/New_York',    1351828800],    //    02-Nov-2012 00:00:00 EDT => 02-Nov-2012 04:00:00 UTC
16
-    [22269,            'Pacific/Auckland',    -285163200],    //    19-Dec-1960 00:00:00 NZST => 18-Dec-1960 12:00:00 UTC
17
-    [25569,            'Pacific/Auckland',    -43200],    //    01-Jan-1970 00:00:00 NZST => 31-Dec-1969 12:00:00 UTC    PHP Base Date
18
-    [30292,            'Pacific/Auckland',    408020400],    //    07-Dec-1982 00:00:00 NZDT => 06-Dec-1982 11:00:00 UTC
19
-    [39611,            'Pacific/Auckland',    1213185600],    //    12-Jun-2008 00:00:00 NZST => 11-Jun-2008 12:00:00 UTC
20
-    [50423.5,          'Pacific/Auckland',    2147382000],    //    18-Jan-2038 12:00:00 NZDT => 17-Jan-2038 23:00:00 UTC    PHP 32-bit Latest Date
21
-    [22345.56789,      'Pacific/Auckland',    -278547734],    //    05-Mar-1961 13:37:46 NZST => 05-Mar-1961 01:37:46 UTC
22
-    [22345.6789,       'Pacific/Auckland',    -278538143],    //    05-Mar-1961 16:17:37 NZST => 05-Mar-1961 04:17:37 UTC
23
-    [0.5,              'Pacific/Auckland',    0],    //    12:00:00 NZST => 00:00:00 UTC
24
-    [0.75,             'Pacific/Auckland',    21600],    //    18:00.00 NZST => 06:00:00 UTC
25
-    [0.12345,          'Pacific/Auckland',    -32534],    //    02:57:46 NZST => 14:57:46 UTC
26
-    [41215,            'Pacific/Auckland',    1351767600],    //    02-Nov-2012 00:00:00 NZDT => 01-Nov-2012 11:00:00 UTC
5
+    [22269, 'America/New_York', -285102000], //    19-Dec-1960 00:00:00 EST => 19-Dec-1960 05:00:00 UTC
6
+    [25569, 'America/New_York', 18000], //    01-Jan-1970 00:00:00 EST => 01-Jan-1970 05:00:00 UTC    PHP Base Date
7
+    [30292, 'America/New_York', 408085200], //    07-Dec-1982 00:00:00 EST => 07-Dec-1982 05:00:00 UTC
8
+    [39611, 'America/New_York', 1213243200], //    12-Jun-2008 00:00:00 EDT => 12-Jun-2008 04:00:00 UTC
9
+    [50424, 'America/New_York', 2147490000], //    19-Jan-2038 00:00:00 EST => 19-Jan-2038 05:00:00 UTC    PHP 32-bit Latest Date
10
+    [22345.56789, 'America/New_York', -278486534], //    05-Mar-1961 13:37:46 EST => 05-Mar-1961 18:37:46 UTC
11
+    [22345.6789, 'America/New_York', -278476943], //    05-Mar-1961 16:17:37 EST => 05-Mar-1961 21:17:37 UTC
12
+    [0.5, 'America/New_York', 61200], //    12:00:00 EST => 17:00:00 UTC
13
+    [0.75, 'America/New_York', 82800], //    18:00.00 EST => 23:00:00 UTC
14
+    [0.12345, 'America/New_York', 28666], //    02:57:46 EST => 07:57:46 UTC
15
+    [41215, 'America/New_York', 1351828800], //    02-Nov-2012 00:00:00 EDT => 02-Nov-2012 04:00:00 UTC
16
+    [22269, 'Pacific/Auckland', -285163200], //    19-Dec-1960 00:00:00 NZST => 18-Dec-1960 12:00:00 UTC
17
+    [25569, 'Pacific/Auckland', -43200], //    01-Jan-1970 00:00:00 NZST => 31-Dec-1969 12:00:00 UTC    PHP Base Date
18
+    [30292, 'Pacific/Auckland', 408020400], //    07-Dec-1982 00:00:00 NZDT => 06-Dec-1982 11:00:00 UTC
19
+    [39611, 'Pacific/Auckland', 1213185600], //    12-Jun-2008 00:00:00 NZST => 11-Jun-2008 12:00:00 UTC
20
+    [50423.5, 'Pacific/Auckland', 2147382000], //    18-Jan-2038 12:00:00 NZDT => 17-Jan-2038 23:00:00 UTC    PHP 32-bit Latest Date
21
+    [22345.56789, 'Pacific/Auckland', -278547734], //    05-Mar-1961 13:37:46 NZST => 05-Mar-1961 01:37:46 UTC
22
+    [22345.6789, 'Pacific/Auckland', -278538143], //    05-Mar-1961 16:17:37 NZST => 05-Mar-1961 04:17:37 UTC
23
+    [0.5, 'Pacific/Auckland', 0], //    12:00:00 NZST => 00:00:00 UTC
24
+    [0.75, 'Pacific/Auckland', 21600], //    18:00.00 NZST => 06:00:00 UTC
25
+    [0.12345, 'Pacific/Auckland', -32534], //    02:57:46 NZST => 14:57:46 UTC
26
+    [41215, 'Pacific/Auckland', 1351767600], //    02-Nov-2012 00:00:00 NZDT => 01-Nov-2012 11:00:00 UTC
27 27
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/TimestampToExcel1904.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -2,10 +2,10 @@
 block discarded – undo
2 2
 
3 3
 //  Excel DateTimeStamp  Result
4 4
 return [
5
-    [-1956528000,       1462],
6
-    [-1956441600,       1463],
7
-    [-158803200,        22269],
8
-    [126316800,         25569],
9
-    [534384000,         30292],
10
-    [1339545600,        39611],
5
+    [-1956528000, 1462],
6
+    [-1956441600, 1463],
7
+    [-158803200, 22269],
8
+    [126316800, 25569],
9
+    [534384000, 30292],
10
+    [1339545600, 39611],
11 11
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/ExcelToTimestamp1900.php 1 patch
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -2,18 +2,18 @@
 block discarded – undo
2 2
 
3 3
 // Excel DateTimeStamp  Result            Comments
4 4
 return [
5
-    [714,              -2147472000],    //  PHP 32-bit Earliest Date        14-Dec-1901
6
-    [1461,             -2082931200],    //                                  31-Dec-1903
7
-    [1462,             -2082844800],    //  Excel 1904 Calendar Base Date   01-Jan-1904
8
-    [1463,             -2082758400],    //                                  02-Jan-1904
9
-    [22269,            -285120000],    //                                  19-Dec-1960
10
-    [25569,            0],    //  PHP Base Date                   01-Jan-1970
11
-    [30292,            408067200],    //                                  07-Dec-1982
12
-    [39611,            1213228800],    //                                  12-Jun-2008
13
-    [50424,            2147472000],    //  PHP 32-bit Latest Date          19-Jan-2038
14
-    [1234.56789,       -2102494934],    //                                  18-May-1903 13:37:46
15
-    [12345.6789,       -1142494943],    //                                  18-Oct-1933 16:17:37
16
-    [0.5,              43200],    //                                  12:00:00
17
-    [0.75,             64800],    //                                  18:00.00
18
-    [0.12345,          10666],    //                                  02:57:46
5
+    [714, -2147472000], //  PHP 32-bit Earliest Date        14-Dec-1901
6
+    [1461, -2082931200], //                                  31-Dec-1903
7
+    [1462, -2082844800], //  Excel 1904 Calendar Base Date   01-Jan-1904
8
+    [1463, -2082758400], //                                  02-Jan-1904
9
+    [22269, -285120000], //                                  19-Dec-1960
10
+    [25569, 0], //  PHP Base Date                   01-Jan-1970
11
+    [30292, 408067200], //                                  07-Dec-1982
12
+    [39611, 1213228800], //                                  12-Jun-2008
13
+    [50424, 2147472000], //  PHP 32-bit Latest Date          19-Jan-2038
14
+    [1234.56789, -2102494934], //                                  18-May-1903 13:37:46
15
+    [12345.6789, -1142494943], //                                  18-Oct-1933 16:17:37
16
+    [0.5, 43200], //                                  12:00:00
17
+    [0.75, 64800], //                                  18:00.00
18
+    [0.12345, 10666], //                                  02:57:46
19 19
 ];
Please login to merge, or discard this patch.
tests/data/Shared/Date/ExcelToTimestamp1904.php 1 patch
Spacing   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -2,13 +2,13 @@
 block discarded – undo
2 2
 
3 3
 // Excel DateTimeStamp        Result            Comments
4 4
 return [
5
-    [1462,                   -1956528000],
6
-    [1463,                   -1956441600],
7
-    [22269,                  -158803200],
8
-    [25569,                  126316800],
9
-    [30292,                  534384000],
10
-    [39611,                  1339545600],
11
-    [0.25,                   21600],    //  06:00:00
12
-    [0.3333333333333333333,  28800],    //  08:00.00
13
-    [0.54321,                46933],    //  02:57:46
5
+    [1462, -1956528000],
6
+    [1463, -1956441600],
7
+    [22269, -158803200],
8
+    [25569, 126316800],
9
+    [30292, 534384000],
10
+    [39611, 1339545600],
11
+    [0.25, 21600], //  06:00:00
12
+    [0.3333333333333333333, 28800], //  08:00.00
13
+    [0.54321, 46933], //  02:57:46
14 14
 ];
Please login to merge, or discard this patch.