PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Shared/Date.php

Doc Comments +7 added lines, -9 removed lines

@@ -112,7 +112,7 @@ 
     /**
      * Set the Default timezone to use for dates
      *
-     * @param     string|\DateTimeZone    $timezone    The timezone to set for all Excel datetimestamp to PHP DateTime Object conversions
+     * @param     string|\DateTimeZone    $timeZone    The timezone to set for all Excel datetimestamp to PHP DateTime Object conversions
      * @return    boolean                              Success or failure
      * @throws    \Exception
      */
@@ -141,7 +141,7 @@ 
     /**
      * Validate a timezone
      *
-     * @param     string|\DateTimeZone    $timezone    The timezone to validate, either as a timezone string or object
+     * @param     string|\DateTimeZone    $timeZone    The timezone to validate, either as a timezone string or object
      * @return    \DateTimeZone                        The timezone as a timezone object
      * @throws    \Exception
      */
@@ -158,8 +158,7 @@ 
     /**
      * Convert a MS serialized datetime value from Excel to a PHP Date/Time object
      *
-     * @param     integer|float    $dateValue        MS Excel serialized date/time value
-     * @param     \DateTimeZone|string|null          $timezone            The timezone to assume for the Excel timestamp,
+     * @param     \DateTimeZone|string|null          $timeZone            The timezone to assume for the Excel timestamp,
      *                                                                        if you don't want to treat it as a UTC value
      *                                                                    Use the default (UST) unless you absolutely need a conversion
      * @return    \DateTime                          PHP date/time object
@@ -196,8 +195,7 @@ 
     /**
      * Convert a MS serialized datetime value from Excel to a unix timestamp
      *
-     * @param     integer|float    $dateValue        MS Excel serialized date/time value
-     * @param     \DateTimeZone|string|null          $timezone            The timezone to assume for the Excel timestamp,
+     * @param     \DateTimeZone|string|null          $timeZone            The timezone to assume for the Excel timestamp,
      *                                                                        if you don't want to treat it as a UTC value
      *                                                                    Use the default (UST) unless you absolutely need a conversion
      * @return    integer                            Unix timetamp for this date/time
@@ -212,7 +210,7 @@ 
     /**
      *    Convert a date from PHP to an MS Excel serialized date/time value
      *
-     *    @param    mixed            $dateValue            PHP serialized date/time or date object
+     *    @param    integer            $dateValue            PHP serialized date/time or date object
      *    @return   float|boolean    Excel date/time value
      *                                  or boolean FALSE on failure
      */
@@ -250,7 +248,7 @@ 
     /**
      *    Convert a Unix timestamp to an MS Excel serialized date/time value
      *
-     *    @param    \DateTimeInterface    $dateValue            PHP DateTime object
+     *    @param    integer    $dateValue            PHP DateTime object
      *    @return   float                 MS Excel serialized date/time value
      */
     public static function timestampToExcel($dateValue = 0)
@@ -270,7 +268,7 @@ 
      * @param    integer    $hours
      * @param    integer    $minutes
      * @param    integer    $seconds
-     * @return   integer    Excel date/time value
+     * @return   double    Excel date/time value
      */
     public static function formattedPHPToExcel($year, $month, $day, $hours = 0, $minutes = 0, $seconds = 0)
     {

Spacing +4 added lines, -4 removed lines

@@ -30,8 +30,8 @@ 
 class Date
 {
     /** constants */
-    const CALENDAR_WINDOWS_1900 = 1900;        //    Base date of 1st Jan 1900 = 1.0
-    const CALENDAR_MAC_1904 = 1904;            //    Base date of 2nd Jan 1904 = 1.0
+    const CALENDAR_WINDOWS_1900 = 1900; //    Base date of 1st Jan 1900 = 1.0
+    const CALENDAR_MAC_1904 = 1904; //    Base date of 2nd Jan 1904 = 1.0
 
     /*
      * Names of the months of the year, indexed by shortname
@@ -388,7 +388,7 @@ 
             return false;
         }
         // Try checking for any of the date formatting characters that don't appear within square braces
-        if (preg_match('/(^|\])[^\[]*['.self::$possibleDateFormatCharacters.']/i', $pFormatCode)) {
+        if (preg_match('/(^|\])[^\[]*[' . self::$possibleDateFormatCharacters . ']/i', $pFormatCode)) {
             //    We might also have a format mask containing quoted strings...
             //        we don't want to test for any of our characters within the quoted blocks
             if (strpos($pFormatCode, '"') !== false) {
@@ -396,7 +396,7 @@ 
                 foreach (explode('"', $pFormatCode) as $subVal) {
                     //    Only test in alternate array entries (the non-quoted blocks)
                     if (($segMatcher = !$segMatcher) &&
-                        (preg_match('/(^|\])[^\[]*['.self::$possibleDateFormatCharacters.']/i', $subVal))) {
+                        (preg_match('/(^|\])[^\[]*[' . self::$possibleDateFormatCharacters . ']/i', $subVal))) {
                         return true;
                     }
                 }

tests/PhpSpreadsheet/Shared/DateTest.php

Spacing +16 added lines, -16 removed lines

@@ -14,7 +14,7 @@ 
         );
 
         foreach ($calendarValues as $calendarValue) {
-            $result = call_user_func(array(Date::class,'setExcelCalendar'), $calendarValue);
+            $result = call_user_func(array(Date::class, 'setExcelCalendar'), $calendarValue);
             $this->assertTrue($result);
         }
     }
@@ -22,7 +22,7 @@ 
     public function testSetExcelCalendarWithInvalidValue()
     {
         $unsupportedCalendar = '2012';
-        $result = call_user_func(array(Date::class,'setExcelCalendar'), $unsupportedCalendar);
+        $result = call_user_func(array(Date::class, 'setExcelCalendar'), $unsupportedCalendar);
         $this->assertFalse($result);
     }
 
@@ -32,7 +32,7 @@ 
     public function testDateTimeExcelToTimestamp1900()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_WINDOWS_1900
         );
 
@@ -53,13 +53,13 @@ 
     public function testDateTimeTimestampToExcel1900()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_WINDOWS_1900
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'timestampToExcel'), $args);
+        $result = call_user_func_array(array(Date::class, 'timestampToExcel'), $args);
         $this->assertEquals($expectedResult, $result, null, 1E-5);
     }
 
@@ -74,13 +74,13 @@ 
     public function testDateTimeDateTimeToExcel()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_WINDOWS_1900
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'dateTimeToExcel'), $args);
+        $result = call_user_func_array(array(Date::class, 'dateTimeToExcel'), $args);
         $this->assertEquals($expectedResult, $result, null, 1E-5);
     }
 
@@ -95,13 +95,13 @@ 
     public function testDateTimeFormattedPHPToExcel1900()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_WINDOWS_1900
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'formattedPHPToExcel'), $args);
+        $result = call_user_func_array(array(Date::class, 'formattedPHPToExcel'), $args);
         $this->assertEquals($expectedResult, $result, null, 1E-5);
     }
 
@@ -116,13 +116,13 @@ 
     public function testDateTimeExcelToTimestamp1904()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_MAC_1904
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'excelToTimestamp'), $args);
+        $result = call_user_func_array(array(Date::class, 'excelToTimestamp'), $args);
         $this->assertEquals($expectedResult, $result);
     }
 
@@ -137,13 +137,13 @@ 
     public function testDateTimeTimestampToExcel1904()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_MAC_1904
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'timestampToExcel'), $args);
+        $result = call_user_func_array(array(Date::class, 'timestampToExcel'), $args);
         $this->assertEquals($expectedResult, $result, null, 1E-5);
     }
 
@@ -159,7 +159,7 @@ 
     {
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'isDateTimeFormatCode'), $args);
+        $result = call_user_func_array(array(Date::class, 'isDateTimeFormatCode'), $args);
         $this->assertEquals($expectedResult, $result);
     }
 
@@ -174,13 +174,13 @@ 
     public function testDateTimeExcelToTimestamp1900Timezone()
     {
         $result = call_user_func(
-            array(Date::class,'setExcelCalendar'),
+            array(Date::class, 'setExcelCalendar'),
             Date::CALENDAR_WINDOWS_1900
         );
 
         $args = func_get_args();
         $expectedResult = array_pop($args);
-        $result = call_user_func_array(array(Date::class,'excelToTimestamp'), $args);
+        $result = call_user_func_array(array(Date::class, 'excelToTimestamp'), $args);
         $this->assertEquals($expectedResult, $result);
     }
 

tests/rawTestData/Shared/Date/DateTimeToExcel.php

Spacing +15 added lines, -15 removed lines

@@ -2,19 +2,19 @@
 
 // DateTime object                          Result           Comments
 return [
-    [ new DateTime('1900-01-01'),           1.0        ],    //  Excel 1900 base calendar date
-    [ new DateTime('1900-02-28'),           59.0       ],    //  This and next test show gap for the mythical
-    [ new DateTime('1900-03-01'),           61.0       ],    //      MS Excel 1900 Leap Year
-    [ new DateTime('1901-12-14'),           714.0      ],    //  Unix Timestamp 32-bit Earliest Date
-    [ new DateTime('1903-12-31'),           1461.0     ],
-    [ new DateTime('1904-01-01'),           1462.0     ],    //  Excel 1904 Calendar Base Date
-    [ new DateTime('1904-01-02'),           1463.0     ],
-    [ new DateTime('1960-12-19'),           22269.0    ],
-    [ new DateTime('1970-01-01'),           25569.0    ],    //  Unix Timestamp Base Date
-    [ new DateTime('1982-12-07'),           30292.0    ],
-    [ new DateTime('2008-06-12'),           39611.0    ],
-    [ new DateTime('2038-01-19'),           50424.0    ],    //  Unix Timestamp 32-bit Latest Date
-    [ new DateTime('1903-05-18 13:37:46'),  1234.56789 ],
-    [ new DateTime('1933-10-18 16:17:37'),  12345.6789 ],
-    [ new DateTime('2099-12-31'),           73050.0    ],
+    [new DateTime('1900-01-01'), 1.0], //  Excel 1900 base calendar date
+    [new DateTime('1900-02-28'), 59.0], //  This and next test show gap for the mythical
+    [new DateTime('1900-03-01'), 61.0], //      MS Excel 1900 Leap Year
+    [new DateTime('1901-12-14'), 714.0], //  Unix Timestamp 32-bit Earliest Date
+    [new DateTime('1903-12-31'), 1461.0],
+    [new DateTime('1904-01-01'), 1462.0], //  Excel 1904 Calendar Base Date
+    [new DateTime('1904-01-02'), 1463.0],
+    [new DateTime('1960-12-19'), 22269.0],
+    [new DateTime('1970-01-01'), 25569.0], //  Unix Timestamp Base Date
+    [new DateTime('1982-12-07'), 30292.0],
+    [new DateTime('2008-06-12'), 39611.0],
+    [new DateTime('2038-01-19'), 50424.0], //  Unix Timestamp 32-bit Latest Date
+    [new DateTime('1903-05-18 13:37:46'), 1234.56789],
+    [new DateTime('1933-10-18 16:17:37'), 12345.6789],
+    [new DateTime('2099-12-31'), 73050.0],
 ];

tests/rawTestData/Shared/Date/FormattedPHPToExcel1900.php

Spacing +11 added lines, -11 removed lines

@@ -2,15 +2,15 @@
 
 //    Year   Month  Day  Hours  Minutes  Seconds  Result            Comments
 return [
-    [ 1901,  12,    14,                           714         ],    //    PHP 32-bit Earliest Date        14-Dec-1901
-    [ 1903,  12,    31,                           1461        ],    //                                    31-Dec-1903
-    [ 1904,  1,     1,                            1462        ],    //    Excel 1904 Calendar Base Date   01-Jan-1904
-    [ 1904,  1,     2,                            1463        ],    //                                    02-Jan-1904
-    [ 1960,  12,    19,                           22269       ],    //                                    19-Dec-1960
-    [ 1970,  1,     1,                            25569       ],    //    PHP Base Date                   01-Jan-1970
-    [ 1982,  12,    7,                            30292       ],    //                                    07-Dec-1982
-    [ 2008,  6,     12,                           39611       ],    //                                    12-Jun-2008
-    [ 2038,  1,     19,                           50424       ],    //    PHP 32-bit Latest Date          19-Jan-2038
-    [ 1903,  5,     18,  13,    37,      46,      1234.56789  ],    //                                    18-May-1903 13:37:46
-    [ 1933,  10,    18,  16,    17,      37,      12345.6789  ],    //                                    18-Oct-1933 16:17:37
+    [1901, 12, 14, 714], //    PHP 32-bit Earliest Date        14-Dec-1901
+    [1903, 12, 31, 1461], //                                    31-Dec-1903
+    [1904, 1, 1, 1462], //    Excel 1904 Calendar Base Date   01-Jan-1904
+    [1904, 1, 2, 1463], //                                    02-Jan-1904
+    [1960, 12, 19, 22269], //                                    19-Dec-1960
+    [1970, 1, 1, 25569], //    PHP Base Date                   01-Jan-1970
+    [1982, 12, 7, 30292], //                                    07-Dec-1982
+    [2008, 6, 12, 39611], //                                    12-Jun-2008
+    [2038, 1, 19, 50424], //    PHP 32-bit Latest Date          19-Jan-2038
+    [1903, 5, 18, 13, 37, 46, 1234.56789], //                                    18-May-1903 13:37:46
+    [1933, 10, 18, 16, 17, 37, 12345.6789], //                                    18-Oct-1933 16:17:37
 ];

tests/rawTestData/Shared/Date/ExcelToTimestamp1900Timezone.php

Spacing +22 added lines, -22 removed lines

@@ -2,26 +2,26 @@
 
 // Excel DateTimeStamp  Timezone               Result            Comments
 return [
-    [ 22269,            'America/New_York',    -285102000  ],    //    19-Dec-1960 00:00:00 EST => 19-Dec-1960 05:00:00 UTC
-    [ 25569,            'America/New_York',    18000       ],    //    01-Jan-1970 00:00:00 EST => 01-Jan-1970 05:00:00 UTC    PHP Base Date
-    [ 30292,            'America/New_York',    408085200   ],    //    07-Dec-1982 00:00:00 EST => 07-Dec-1982 05:00:00 UTC
-    [ 39611,            'America/New_York',    1213243200  ],    //    12-Jun-2008 00:00:00 EDT => 12-Jun-2008 04:00:00 UTC
-    [ 50424,            'America/New_York',    2147490000  ],    //    19-Jan-2038 00:00:00 EST => 19-Jan-2038 05:00:00 UTC    PHP 32-bit Latest Date
-    [ 22345.56789,      'America/New_York',    -278486534  ],    //    05-Mar-1961 13:37:46 EST => 05-Mar-1961 18:37:46 UTC
-    [ 22345.6789,       'America/New_York',    -278476943  ],    //    05-Mar-1961 16:17:37 EST => 05-Mar-1961 21:17:37 UTC
-    [ 0.5,              'America/New_York',    61200       ],    //    12:00:00 EST => 17:00:00 UTC
-    [ 0.75,             'America/New_York',    82800       ],    //    18:00.00 EST => 23:00:00 UTC
-    [ 0.12345,          'America/New_York',    28666       ],    //    02:57:46 EST => 07:57:46 UTC
-    [ 41215,            'America/New_York',    1351828800  ],    //    02-Nov-2012 00:00:00 EDT => 02-Nov-2012 04:00:00 UTC
-    [ 22269,            'Pacific/Auckland',    -285163200  ],    //    19-Dec-1960 00:00:00 NZST => 18-Dec-1960 12:00:00 UTC
-    [ 25569,            'Pacific/Auckland',    -43200      ],    //    01-Jan-1970 00:00:00 NZST => 31-Dec-1969 12:00:00 UTC    PHP Base Date
-    [ 30292,            'Pacific/Auckland',    408020400   ],    //    07-Dec-1982 00:00:00 NZDT => 06-Dec-1982 11:00:00 UTC
-    [ 39611,            'Pacific/Auckland',    1213185600  ],    //    12-Jun-2008 00:00:00 NZST => 11-Jun-2008 12:00:00 UTC
-    [ 50423.5,          'Pacific/Auckland',    2147382000  ],    //    18-Jan-2038 12:00:00 NZDT => 17-Jan-2038 23:00:00 UTC    PHP 32-bit Latest Date
-    [ 22345.56789,      'Pacific/Auckland',    -278547734  ],    //    05-Mar-1961 13:37:46 NZST => 05-Mar-1961 01:37:46 UTC
-    [ 22345.6789,       'Pacific/Auckland',    -278538143  ],    //    05-Mar-1961 16:17:37 NZST => 05-Mar-1961 04:17:37 UTC
-    [ 0.5,              'Pacific/Auckland',    0           ],    //    12:00:00 NZST => 00:00:00 UTC
-    [ 0.75,             'Pacific/Auckland',    21600       ],    //    18:00.00 NZST => 06:00:00 UTC
-    [ 0.12345,          'Pacific/Auckland',    -32534      ],    //    02:57:46 NZST => 14:57:46 UTC
-    [ 41215,            'Pacific/Auckland',    1351767600  ],    //    02-Nov-2012 00:00:00 NZDT => 01-Nov-2012 11:00:00 UTC
+    [22269, 'America/New_York', -285102000], //    19-Dec-1960 00:00:00 EST => 19-Dec-1960 05:00:00 UTC
+    [25569, 'America/New_York', 18000], //    01-Jan-1970 00:00:00 EST => 01-Jan-1970 05:00:00 UTC    PHP Base Date
+    [30292, 'America/New_York', 408085200], //    07-Dec-1982 00:00:00 EST => 07-Dec-1982 05:00:00 UTC
+    [39611, 'America/New_York', 1213243200], //    12-Jun-2008 00:00:00 EDT => 12-Jun-2008 04:00:00 UTC
+    [50424, 'America/New_York', 2147490000], //    19-Jan-2038 00:00:00 EST => 19-Jan-2038 05:00:00 UTC    PHP 32-bit Latest Date
+    [22345.56789, 'America/New_York', -278486534], //    05-Mar-1961 13:37:46 EST => 05-Mar-1961 18:37:46 UTC
+    [22345.6789, 'America/New_York', -278476943], //    05-Mar-1961 16:17:37 EST => 05-Mar-1961 21:17:37 UTC
+    [0.5, 'America/New_York', 61200], //    12:00:00 EST => 17:00:00 UTC
+    [0.75, 'America/New_York', 82800], //    18:00.00 EST => 23:00:00 UTC
+    [0.12345, 'America/New_York', 28666], //    02:57:46 EST => 07:57:46 UTC
+    [41215, 'America/New_York', 1351828800], //    02-Nov-2012 00:00:00 EDT => 02-Nov-2012 04:00:00 UTC
+    [22269, 'Pacific/Auckland', -285163200], //    19-Dec-1960 00:00:00 NZST => 18-Dec-1960 12:00:00 UTC
+    [25569, 'Pacific/Auckland', -43200], //    01-Jan-1970 00:00:00 NZST => 31-Dec-1969 12:00:00 UTC    PHP Base Date
+    [30292, 'Pacific/Auckland', 408020400], //    07-Dec-1982 00:00:00 NZDT => 06-Dec-1982 11:00:00 UTC
+    [39611, 'Pacific/Auckland', 1213185600], //    12-Jun-2008 00:00:00 NZST => 11-Jun-2008 12:00:00 UTC
+    [50423.5, 'Pacific/Auckland', 2147382000], //    18-Jan-2038 12:00:00 NZDT => 17-Jan-2038 23:00:00 UTC    PHP 32-bit Latest Date
+    [22345.56789, 'Pacific/Auckland', -278547734], //    05-Mar-1961 13:37:46 NZST => 05-Mar-1961 01:37:46 UTC
+    [22345.6789, 'Pacific/Auckland', -278538143], //    05-Mar-1961 16:17:37 NZST => 05-Mar-1961 04:17:37 UTC
+    [0.5, 'Pacific/Auckland', 0], //    12:00:00 NZST => 00:00:00 UTC
+    [0.75, 'Pacific/Auckland', 21600], //    18:00.00 NZST => 06:00:00 UTC
+    [0.12345, 'Pacific/Auckland', -32534], //    02:57:46 NZST => 14:57:46 UTC
+    [41215, 'Pacific/Auckland', 1351767600], //    02-Nov-2012 00:00:00 NZDT => 01-Nov-2012 11:00:00 UTC
 ];

tests/rawTestData/Shared/Date/ExcelToTimestamp1900.php

Spacing +14 added lines, -14 removed lines

@@ -2,18 +2,18 @@
 
 // Excel DateTimeStamp  Result            Comments
 return [
-    [ 714,              -2147472000 ],    //  PHP 32-bit Earliest Date        14-Dec-1901
-    [ 1461,             -2082931200 ],    //                                  31-Dec-1903
-    [ 1462,             -2082844800 ],    //  Excel 1904 Calendar Base Date   01-Jan-1904
-    [ 1463,             -2082758400 ],    //                                  02-Jan-1904
-    [ 22269,            -285120000  ],    //                                  19-Dec-1960
-    [ 25569,            0           ],    //  PHP Base Date                   01-Jan-1970
-    [ 30292,            408067200   ],    //                                  07-Dec-1982
-    [ 39611,            1213228800  ],    //                                  12-Jun-2008
-    [ 50424,            2147472000  ],    //  PHP 32-bit Latest Date          19-Jan-2038
-    [ 1234.56789,       -2102494934 ],    //                                  18-May-1903 13:37:46
-    [ 12345.6789,       -1142494943 ],    //                                  18-Oct-1933 16:17:37
-    [ 0.5,              43200       ],    //                                  12:00:00
-    [ 0.75,             64800       ],    //                                  18:00.00
-    [ 0.12345,          10666       ],    //                                  02:57:46
+    [714, -2147472000], //  PHP 32-bit Earliest Date        14-Dec-1901
+    [1461, -2082931200], //                                  31-Dec-1903
+    [1462, -2082844800], //  Excel 1904 Calendar Base Date   01-Jan-1904
+    [1463, -2082758400], //                                  02-Jan-1904
+    [22269, -285120000], //                                  19-Dec-1960
+    [25569, 0], //  PHP Base Date                   01-Jan-1970
+    [30292, 408067200], //                                  07-Dec-1982
+    [39611, 1213228800], //                                  12-Jun-2008
+    [50424, 2147472000], //  PHP 32-bit Latest Date          19-Jan-2038
+    [1234.56789, -2102494934], //                                  18-May-1903 13:37:46
+    [12345.6789, -1142494943], //                                  18-Oct-1933 16:17:37
+    [0.5, 43200], //                                  12:00:00
+    [0.75, 64800], //                                  18:00.00
+    [0.12345, 10666], //                                  02:57:46
 ];

tests/rawTestData/Shared/Date/TimestampToExcel1900.php

Spacing +11 added lines, -11 removed lines

@@ -2,15 +2,15 @@
 
 // Unix TimeStamp   Result           Comments
 return [
-    [ -2147472000,  714        ],    //  PHP 32-bit Earliest Date        14-Dec-1901
-    [ -2082931200,  1461       ],    //                                  31-Dec-1903
-    [ -2082844800,  1462       ],    //  Excel 1904 Calendar Base Date   01-Jan-1904
-    [ -2082758400,  1463       ],    //                                  02-Jan-1904
-    [ -285120000,   22269      ],    //                                  19-Dec-1960
-    [ 0,            25569      ],    //  PHP Base Date                   01-Jan-1970
-    [ 408067200,    30292      ],    //                                  07-Dec-1982
-    [ 1213228800,   39611      ],    //                                  12-Jun-2008
-    [ 2147472000,   50424      ],    //  PHP 32-bit Latest Date          19-Jan-2038
-    [ -2102494934,  1234.56789 ],    //                                  18-May-1903 13:37:46
-    [ -1142494943,  12345.6789 ],    //                                  18-Oct-1933 16:17:37
+    [ -2147472000, 714], //  PHP 32-bit Earliest Date        14-Dec-1901
+    [ -2082931200, 1461], //                                  31-Dec-1903
+    [ -2082844800, 1462], //  Excel 1904 Calendar Base Date   01-Jan-1904
+    [ -2082758400, 1463], //                                  02-Jan-1904
+    [ -285120000, 22269], //                                  19-Dec-1960
+    [0, 25569], //  PHP Base Date                   01-Jan-1970
+    [408067200, 30292], //                                  07-Dec-1982
+    [1213228800, 39611], //                                  12-Jun-2008
+    [2147472000, 50424], //  PHP 32-bit Latest Date          19-Jan-2038
+    [ -2102494934, 1234.56789], //                                  18-May-1903 13:37:46
+    [ -1142494943, 12345.6789], //                                  18-Oct-1933 16:17:37
 ];

tests/rawTestData/Shared/Date/FormatCodes.php

Spacing +36 added lines, -36 removed lines

@@ -2,40 +2,40 @@
 
 //  Excel Format Code                     Result
 return [
-    [ 'General',                          FALSE ],
-    [ '@',                                FALSE ],
-    [ '0',                                FALSE ],
-    [ '0.00',                             FALSE ],
-    [ '#,##0.00',                         FALSE ],
-    [ '#,##0.00_-',                       FALSE ],
-    [ '0%',                               FALSE ],
-    [ '0.00%',                            FALSE ],
-    [ 'yyyy-mm-dd',                       TRUE  ],
-    [ 'yy-mm-dd',                         TRUE  ],
-    [ 'dd/mm/yy',                         TRUE  ],
-    [ 'd/m/y',                            TRUE  ],
-    [ 'd-m-y',                            TRUE  ],
-    [ 'd-m',                              TRUE  ],
-    [ 'm-y',                              TRUE  ],
-    [ 'mm-dd-yy',                         TRUE  ],
-    [ 'd-mmm-yy',                         TRUE  ],
-    [ 'd-mmm',                            TRUE  ],
-    [ 'mmm-yy',                           TRUE  ],
-    [ 'm/d/yy h:mm',                      TRUE  ],
-    [ 'd/m/y h:mm',                       TRUE  ],
-    [ 'h:mm AM/PM',                       TRUE  ],
-    [ 'h:mm:ss AM/PM',                    TRUE  ],
-    [ 'h:mm',                             TRUE  ],
-    [ 'h:mm:ss',                          TRUE  ],
-    [ 'mm:ss',                            TRUE  ],
-    [ 'h:mm:ss',                          TRUE  ],
-    [ 'i:s.S',                            TRUE  ],
-    [ 'h:mm:ss;@',                        TRUE  ],
-    [ 'yy/mm/dd;@',                       TRUE  ],
-    [ '"$" #,##0.00_-',                   FALSE ],
-    [ '$#,##0_-',                         FALSE ],
-    [ '[$EUR ]#,##0.00_-',                FALSE ],
-    [ '_[$EUR ]#,##0.00_-',               FALSE ],
-    [ '[Green]#,##0.00;[Red]#,##0.00_-',  FALSE ],
-    [ '#,##0.00 "dollars"',               FALSE ],
+    ['General', FALSE],
+    ['@', FALSE],
+    ['0', FALSE],
+    ['0.00', FALSE],
+    ['#,##0.00', FALSE],
+    ['#,##0.00_-', FALSE],
+    ['0%', FALSE],
+    ['0.00%', FALSE],
+    ['yyyy-mm-dd', TRUE],
+    ['yy-mm-dd', TRUE],
+    ['dd/mm/yy', TRUE],
+    ['d/m/y', TRUE],
+    ['d-m-y', TRUE],
+    ['d-m', TRUE],
+    ['m-y', TRUE],
+    ['mm-dd-yy', TRUE],
+    ['d-mmm-yy', TRUE],
+    ['d-mmm', TRUE],
+    ['mmm-yy', TRUE],
+    ['m/d/yy h:mm', TRUE],
+    ['d/m/y h:mm', TRUE],
+    ['h:mm AM/PM', TRUE],
+    ['h:mm:ss AM/PM', TRUE],
+    ['h:mm', TRUE],
+    ['h:mm:ss', TRUE],
+    ['mm:ss', TRUE],
+    ['h:mm:ss', TRUE],
+    ['i:s.S', TRUE],
+    ['h:mm:ss;@', TRUE],
+    ['yy/mm/dd;@', TRUE],
+    ['"$" #,##0.00_-', FALSE],
+    ['$#,##0_-', FALSE],
+    ['[$EUR ]#,##0.00_-', FALSE],
+    ['_[$EUR ]#,##0.00_-', FALSE],
+    ['[Green]#,##0.00;[Red]#,##0.00_-', FALSE],
+    ['#,##0.00 "dollars"', FALSE],
 ];

tests/rawTestData/Shared/Date/TimestampToExcel1904.php

Spacing +6 added lines, -6 removed lines

@@ -2,10 +2,10 @@
 
 //  Excel DateTimeStamp  Result
 return [
-    [ -1956528000,       1462  ],
-    [ -1956441600,       1463  ],
-    [ -158803200,        22269 ],
-    [ 126316800,         25569 ],
-    [ 534384000,         30292 ],
-    [ 1339545600,        39611 ],
+    [ -1956528000, 1462],
+    [ -1956441600, 1463],
+    [ -158803200, 22269],
+    [126316800, 25569],
+    [534384000, 30292],
+    [1339545600, 39611],
 ];