View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( 685e29...09d456 )
by Adrien
14:14
created
Status
Category
Toggle Patches
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.