@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | $testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30], |
34 | 34 | [15, 15, 15], [5], [9, 15, 0], [9, 15, -1], |
35 | 35 | [13, -14, -15], [0, 0, -1], |
36 | - ]; |
|
36 | + ]; |
|
37 | 37 | $testDateCount = count($testDates); |
38 | 38 | |
39 | 39 | $worksheet->fromArray($testDates, null, 'A1', true); |
@@ -43,8 +43,8 @@ discard block |
||
43 | 43 | $worksheet->setCellValue('E' . $row, '=D' . $row); |
44 | 44 | } |
45 | 45 | $worksheet->getStyle('E1:E' . $testDateCount) |
46 | - ->getNumberFormat() |
|
47 | - ->setFormatCode('hh:mm:ss'); |
|
46 | + ->getNumberFormat() |
|
47 | + ->setFormatCode('hh:mm:ss'); |
|
48 | 48 | |
49 | 49 | echo '<hr />'; |
50 | 50 |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | '2012-Oct-31', '5th November', 'January 1st', 'April 2012', |
35 | 35 | '17-03', '03-2012', '29 Feb 2011', '03-05-07', |
36 | 36 | '03-MAY-07', '03-13-07', |
37 | - ]; |
|
37 | + ]; |
|
38 | 38 | $testDateCount = count($testDates); |
39 | 39 | |
40 | 40 | for ($row = 1; $row <= $testDateCount; ++$row) { |
@@ -44,8 +44,8 @@ discard block |
||
44 | 44 | } |
45 | 45 | |
46 | 46 | $worksheet->getStyle('C1:C' . $testDateCount) |
47 | - ->getNumberFormat() |
|
48 | - ->setFormatCode('yyyy-mmm-dd'); |
|
47 | + ->getNumberFormat() |
|
48 | + ->setFormatCode('yyyy-mmm-dd'); |
|
49 | 49 | |
50 | 50 | echo '<hr />'; |
51 | 51 |
@@ -31,7 +31,7 @@ discard block |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM', |
34 | - ]; |
|
34 | + ]; |
|
35 | 35 | $testDateCount = count($testDates); |
36 | 36 | |
37 | 37 | for ($row = 1; $row <= $testDateCount; ++$row) { |
@@ -41,8 +41,8 @@ discard block |
||
41 | 41 | } |
42 | 42 | |
43 | 43 | $worksheet->getStyle('C1:C' . $testDateCount) |
44 | - ->getNumberFormat() |
|
45 | - ->setFormatCode('hh:mm:ss'); |
|
44 | + ->getNumberFormat() |
|
45 | + ->setFormatCode('hh:mm:ss'); |
|
46 | 46 | |
47 | 47 | echo '<hr />'; |
48 | 48 |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45], |
36 | 36 | [2012, 0, 0], [2012, 1, 0], [2012, 0, 1], |
37 | 37 | [2012, -2, 2], [2012, 2, -2], [2012, -2, -2], |
38 | - ]; |
|
38 | + ]; |
|
39 | 39 | $testDateCount = count($testDates); |
40 | 40 | |
41 | 41 | $worksheet->fromArray($testDates, null, 'A1', true); |
@@ -45,8 +45,8 @@ discard block |
||
45 | 45 | $worksheet->setCellValue('E' . $row, '=D' . $row); |
46 | 46 | } |
47 | 47 | $worksheet->getStyle('E1:E' . $testDateCount) |
48 | - ->getNumberFormat() |
|
49 | - ->setFormatCode('yyyy-mmm-dd'); |
|
48 | + ->getNumberFormat() |
|
49 | + ->setFormatCode('yyyy-mmm-dd'); |
|
50 | 50 | |
51 | 51 | echo '<hr />'; |
52 | 52 |