PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/DateTime.php

Indentation +9 added lines, -9 removed lines

@@ -1149,15 +1149,15 @@
             return Functions::VALUE();
         }
 
-		if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
-			if ($dateValue < 1.0) {
-				return 0;
-			} elseif ($dateValue < 0.0) {
-				return Functions::NAN();
-			}
-		}
-
-		// Execute function
+        if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
+            if ($dateValue < 1.0) {
+                return 0;
+            } elseif ($dateValue < 0.0) {
+                return Functions::NAN();
+            }
+        }
+
+        // Execute function
         $PHPDateObject = Date::excelToDateTimeObject($dateValue);
 
         return (int) $PHPDateObject->format('j');

src/PhpSpreadsheet/Shared/Date.php

Indentation +20 added lines, -20 removed lines

@@ -186,23 +186,23 @@ 
     public static function excelToDateTimeObject($excelTimestamp, $timeZone = null)
     {
         $timeZone = ($timeZone === null) ? self::getDefaultTimezone() : self::validateTimeZone($timeZone);
-		if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
-			if ($excelTimestamp < 1.0) {
-				// Unix timestamp base date
-				$baseDate = new \DateTime('1970-01-01', $timeZone);
-			} else {
-				// MS Excel calendar base dates
-				if (self::$excelCalendar == self::CALENDAR_WINDOWS_1900) {
-					// Allow adjustment for 1900 Leap Year in MS Excel
-					$baseDate = ($excelTimestamp < 60) ? new \DateTime('1899-12-31', $timeZone) : new \DateTime('1899-12-30', $timeZone);
-				} else {
-					$baseDate = new \DateTime('1904-01-01', $timeZone);
-				}
-			}
-		}
-		else {
-			$baseDate = new \DateTime('1899-12-30', $timeZone);
-		}
+        if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
+            if ($excelTimestamp < 1.0) {
+                // Unix timestamp base date
+                $baseDate = new \DateTime('1970-01-01', $timeZone);
+            } else {
+                // MS Excel calendar base dates
+                if (self::$excelCalendar == self::CALENDAR_WINDOWS_1900) {
+                    // Allow adjustment for 1900 Leap Year in MS Excel
+                    $baseDate = ($excelTimestamp < 60) ? new \DateTime('1899-12-31', $timeZone) : new \DateTime('1899-12-30', $timeZone);
+                } else {
+                    $baseDate = new \DateTime('1904-01-01', $timeZone);
+                }
+            }
+        }
+        else {
+            $baseDate = new \DateTime('1899-12-30', $timeZone);
+        }
 
         $days = floor($excelTimestamp);
         $partDay = $excelTimestamp - $days;
@@ -212,9 +212,9 @@ 
         $partDay = $partDay * 60 - $minutes;
         $seconds = round($partDay * 60);
 
-		if ($days >= 0) {
-	        $days = '+' . $days;
-		}
+        if ($days >= 0) {
+            $days = '+' . $days;
+        }
         $interval = $days . ' days';
 
         return $baseDate->modify($interval)