View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( d19f73...aa97bb )
by
unknown
08:38
created
Status
Category
Toggle Patches
tests/rawTestData/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/rawTestData/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.