@@ -113,7 +113,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
150 | 150 | { |
151 | 151 | $attributeSet = ['val' => 100, |
152 | 152 | 'maxVal' => 200, |
153 | - ]; |
|
153 | + ]; |
|
154 | 154 | |
155 | 155 | $this->testAutoFilterColumnObject->setAttributes($attributeSet); |
156 | 156 |
@@ -2,15 +2,15 @@ |
||
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 | ]; |
@@ -2,15 +2,15 @@ |
||
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 | ]; |
@@ -2,19 +2,19 @@ |
||
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 | ]; |
@@ -2,40 +2,40 @@ |
||
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 | ]; |
@@ -2,26 +2,26 @@ |
||
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 | ]; |
@@ -2,10 +2,10 @@ |
||
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 | ]; |
@@ -2,18 +2,18 @@ |
||
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 | ]; |
@@ -2,13 +2,13 @@ |
||
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 | ]; |