PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/DateTimeExcel/Date.php

Spacing +1 added lines, -1 removed lines

@@ -64,7 +64,7 @@
      *         If an array of numbers is passed as the argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function fromYMD(array|float|int|string $year, array|float|int|string $month, array|float|int|string $day): float|int|DateTime|string|array
+    public static function fromYMD(array | float | int | string $year, array | float | int | string $month, array | float | int | string $day): float | int | DateTime | string | array
     {
         if (is_array($year) || is_array($month) || is_array($day)) {
             return self::evaluateArrayArguments([self::class, __FUNCTION__], $year, $month, $day);

src/PhpSpreadsheet/Calculation/Calculation.php

Spacing +13 added lines, -13 removed lines

@@ -208,7 +208,7 @@ 
         return array_key_exists($key, self::$excelConstants);
     }
 
-    public static function getExcelConstants(string $key): bool|null
+    public static function getExcelConstants(string $key): bool | null
     {
         return self::$excelConstants[$key];
     }
@@ -3273,10 +3273,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromExcel;
+    private static ? array $functionReplaceFromExcel;
 
     /** @var ?array */
-    private static ?array $functionReplaceToLocale;
+    private static ? array $functionReplaceToLocale;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToLocale() instead
@@ -3322,10 +3322,10 @@ 
     }
 
     /** @var ?array */
-    private static ?array $functionReplaceFromLocale;
+    private static ? array $functionReplaceFromLocale;
 
     /** @var ?array */
-    private static ?array $functionReplaceToExcel;
+    private static ? array $functionReplaceToExcel;
 
     /**
      * @deprecated 1.30.0 use translateFormulaToEnglish() instead
@@ -3533,7 +3533,7 @@ 
      *
      * @param string $formula Formula to parse
      */
-    public function parseFormula(string $formula): array|bool
+    public function parseFormula(string $formula): array | bool
     {
         //    Basic validation that this is indeed a formula
         //    We return an empty array if not
@@ -3927,7 +3927,7 @@ 
     /**
      * @return false|string False indicates an error
      */
-    private function convertMatrixReferences(string $formula): false|string
+    private function convertMatrixReferences(string $formula): false | string
     {
         static $matrixReplaceFrom = [self::FORMULA_OPEN_MATRIX_BRACE, ';', self::FORMULA_CLOSE_MATRIX_BRACE];
         static $matrixReplaceTo = ['MKMATRIX(MKMATRIX(', '),MKMATRIX(', '))'];
@@ -4022,7 +4022,7 @@ 
     /**
      * @return array<int, mixed>|false
      */
-    private function internalParseFormula(string $formula, ?Cell $cell = null): bool|array
+    private function internalParseFormula(string $formula, ?Cell $cell = null): bool | array
     {
         if (($formula = $this->convertMatrixReferences(trim($formula))) === false) {
             return false;
@@ -5153,7 +5153,7 @@ 
         return true;
     }
 
-    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays): array
+    private function executeArrayComparison(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays): array
     {
         $result = [];
         if (!is_array($operand2)) {
@@ -5192,7 +5192,7 @@ 
         return $result;
     }
 
-    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack, bool $recursingArrays = false): array|bool
+    private function executeBinaryComparisonOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack, bool $recursingArrays = false): array | bool
     {
         //    If we're dealing with matrix operations, we want a matrix result
         if ((is_array($operand1)) || (is_array($operand2))) {
@@ -5209,7 +5209,7 @@ 
         return $result;
     }
 
-    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack &$stack): mixed
+    private function executeNumericBinaryOperation(mixed $operand1, mixed $operand2, string $operation, Stack & $stack): mixed
     {
         //    Validate the two operands
         if (
@@ -5414,7 +5414,7 @@ 
      *
      * @return array|string Array of values in range if range contains more than one element. Otherwise, a single value is returned.
      */
-    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string|array
+    public function extractNamedRange(string &$range = 'A1', ?Worksheet $worksheet = null, bool $resetLog = true): string | array
     {
         // Return value
         $returnValue = [];
@@ -5555,7 +5555,7 @@ 
     /**
      * Add cell reference if needed while making sure that it is the last argument.
      */
-    private function addCellReference(array $args, bool $passCellReference, array|string $functionCall, ?Cell $cell = null): array
+    private function addCellReference(array $args, bool $passCellReference, array | string $functionCall, ?Cell $cell = null): array
     {
         if ($passCellReference) {
             if (is_array($functionCall)) {

src/PhpSpreadsheet/Calculation/Statistical/MaxMinBase.php

Spacing +1 added lines, -1 removed lines

@@ -4,7 +4,7 @@
 
 abstract class MaxMinBase
 {
-    protected static function datatypeAdjustmentAllowStrings(int|float|string|bool $value): int|float
+    protected static function datatypeAdjustmentAllowStrings(int | float | string | bool $value): int | float
     {
         if (is_bool($value)) {
             return (int) $value;

src/PhpSpreadsheet/Calculation/Statistical/VarianceBase.php

Spacing +1 added lines, -1 removed lines

@@ -6,7 +6,7 @@
 
 abstract class VarianceBase
 {
-    protected static function datatypeAdjustmentAllowStrings(int|float|string|bool $value): int|float
+    protected static function datatypeAdjustmentAllowStrings(int | float | string | bool $value): int | float
     {
         if (is_bool($value)) {
             return (int) $value;

src/PhpSpreadsheet/Shared/StringHelper.php

Spacing +3 added lines, -3 removed lines

@@ -329,7 +329,7 @@ 
      * Formats a numeric value as a string for output in various output writers forcing
      * point as decimal separator in case locale is other than English.
      */
-    public static function formatNumber(float|int|string|null $numericValue): string
+    public static function formatNumber(float | int | string | null $numericValue): string
     {
         if (is_float($numericValue)) {
             return str_replace(',', '.', (string) $numericValue);
@@ -384,7 +384,7 @@ 
     {
         // characters
         $chars = self::convertEncoding($textValue, 'UTF-16LE', 'UTF-8');
-        $ln = (int) (strlen($chars) / 2);  // N.B. - strlen, not mb_strlen issue #642
+        $ln = (int) (strlen($chars) / 2); // N.B. - strlen, not mb_strlen issue #642
 
         return pack('vC', $ln, 0x0001) . $chars;
     }
@@ -638,7 +638,7 @@ 
      *
      * @return float|string string or only the leading numeric part of the string
      */
-    public static function testStringAsNumeric(string $textValue): float|string
+    public static function testStringAsNumeric(string $textValue): float | string
     {
         if (is_numeric($textValue)) {
             return $textValue;

src/PhpSpreadsheet/Chart/Properties.php

Spacing +10 added lines, -10 removed lines

@@ -178,7 +178,7 @@ 
         return ((float) $value) / self::PERCENTAGE_MULTIPLIER;
     }
 
-    protected function setColorProperties(?string $color, null|float|int|string $alpha, ?string $colorType): array
+    protected function setColorProperties(?string $color, null | float | int | string $alpha, ?string $colorType): array
     {
         return [
             'type' => $colorType,
@@ -403,7 +403,7 @@ 
     /**
      * Get value of array element.
      */
-    protected function getArrayElementsValue(array $properties, array|int|string $elements): mixed
+    protected function getArrayElementsValue(array $properties, array | int | string $elements): mixed
     {
         $reference = &$properties;
         if (!is_array($elements)) {
@@ -437,7 +437,7 @@ 
     /**
      * Get Glow Property.
      */
-    public function getGlowProperty(array|string $property): null|array|float|int|string
+    public function getGlowProperty(array | string $property): null | array | float | int | string
     {
         $retVal = null;
         if ($property === 'size') {
@@ -458,7 +458,7 @@ 
     /**
      * Get Glow Color Property.
      */
-    public function getGlowColor(string $propertyName): null|int|string
+    public function getGlowColor(string $propertyName): null | int | string
     {
         return $this->glowColor->getColorProperty($propertyName);
     }
@@ -522,7 +522,7 @@ 
     /**
      * Set Shadow Properties.
      */
-    public function setShadowProperties(int $presets, ?string $colorValue = null, ?string $colorType = null, null|float|int|string $colorAlpha = null, ?float $blur = null, ?int $angle = null, ?float $distance = null): void
+    public function setShadowProperties(int $presets, ?string $colorValue = null, ?string $colorType = null, null | float | int | string $colorAlpha = null, ?float $blur = null, ?int $angle = null, ?float $distance = null): void
     {
         $this->activateObject()->setShadowPresetsProperties((int) $presets);
         if ($presets === 0) {
@@ -605,7 +605,7 @@ 
      *
      * @return $this
      */
-    protected function setShadowAngle(null|float|int|string $angle)
+    protected function setShadowAngle(null | float | int | string $angle)
     {
         if (is_numeric($angle)) {
             $this->shadowProperties['direction'] = $angle;
@@ -638,7 +638,7 @@ 
      *
      * @param string|string[] $elements
      */
-    public function getShadowProperty($elements): array|string|null
+    public function getShadowProperty($elements): array | string | null
     {
         if ($elements === 'color') {
             return [
@@ -718,7 +718,7 @@ 
     /**
      * Get Line Color Property.
      */
-    public function getLineColorProperty(string $propertyName): null|int|string
+    public function getLineColorProperty(string $propertyName): null | int | string
     {
         return $this->lineColor->getColorProperty($propertyName);
     }
@@ -727,7 +727,7 @@ 
      * Set Line Style Properties.
      */
     public function setLineStyleProperties(
-        null|float|int|string $lineWidth = null,
+        null | float | int | string $lineWidth = null,
         ?string $compoundType = '',
         ?string $dashType = '',
         ?string $capType = '',
@@ -823,7 +823,7 @@ 
     /**
      * Get Line Style Property.
      */
-    public function getLineStyleProperty(array|string $elements): ?string
+    public function getLineStyleProperty(array | string $elements): ?string
     {
         return $this->getArrayElementsValue($this->lineStyleProperties, $elements);
     }

src/PhpSpreadsheet/Chart/DataSeries.php

Spacing +5 added lines, -5 removed lines

@@ -113,8 +113,8 @@ 
      * @param DataSeriesValues[] $plotValues
      */
     public function __construct(
-        null|string $plotType = null,
-        null|string $plotGrouping = null,
+        null | string $plotType = null,
+        null | string $plotGrouping = null,
         array $plotOrder = [],
         array $plotLabel = [],
         array $plotCategory = [],
@@ -232,7 +232,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotLabelByIndex(int $index): bool|DataSeriesValues
+    public function getPlotLabelByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotLabel);
         if (in_array($index, $keys)) {
@@ -257,7 +257,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotCategoryByIndex(int $index): bool|DataSeriesValues
+    public function getPlotCategoryByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotCategory);
         if (in_array($index, $keys)) {
@@ -304,7 +304,7 @@ 
      *
      * @return DataSeriesValues|false
      */
-    public function getPlotValuesByIndex(int $index): bool|DataSeriesValues
+    public function getPlotValuesByIndex(int $index): bool | DataSeriesValues
     {
         $keys = array_keys($this->plotValues);
         if (in_array($index, $keys)) {

src/PhpSpreadsheet/Reader/Xls/Escher.php

Spacing +3 added lines, -3 removed lines

@@ -51,12 +51,12 @@ 
     /**
      * The object to be returned by the reader. Modified during load.
      */
-    private BSE|BstoreContainer|DgContainer|DggContainer|\PhpOffice\PhpSpreadsheet\Shared\Escher|SpContainer|SpgrContainer $object;
+    private BSE | BstoreContainer | DgContainer | DggContainer | \PhpOffice\PhpSpreadsheet\Shared\Escher | SpContainer | SpgrContainer $object;
 
     /**
      * Create a new Escher instance.
      */
-    public function __construct(BSE|BstoreContainer|DgContainer|DggContainer|\PhpOffice\PhpSpreadsheet\Shared\Escher|SpContainer|SpgrContainer $object)
+    public function __construct(BSE | BstoreContainer | DgContainer | DggContainer | \PhpOffice\PhpSpreadsheet\Shared\Escher | SpContainer | SpgrContainer $object)
     {
         $this->object = $object;
     }
@@ -85,7 +85,7 @@ 
     /**
      * Load Escher stream data. May be a partial Escher stream.
      */
-    public function load(string $data): BSE|BstoreContainer|DgContainer|DggContainer|\PhpOffice\PhpSpreadsheet\Shared\Escher|SpContainer|SpgrContainer
+    public function load(string $data): BSE | BstoreContainer | DgContainer | DggContainer | \PhpOffice\PhpSpreadsheet\Shared\Escher | SpContainer | SpgrContainer
     {
         $this->data = $data;
 

src/PhpSpreadsheet/Writer/Xls/Escher.php

Spacing +2 added lines, -2 removed lines

@@ -17,7 +17,7 @@ 
     /**
      * The object we are writing.
      */
-    private Blip|BSE|BstoreContainer|DgContainer|DggContainer|Escher|SpContainer|SpgrContainer|SharedEscher $object;
+    private Blip | BSE | BstoreContainer | DgContainer | DggContainer | Escher | SpContainer | SpgrContainer | SharedEscher $object;
 
     /**
      * The written binary data.
@@ -37,7 +37,7 @@ 
     /**
      * Constructor.
      */
-    public function __construct(Blip|BSE|BstoreContainer|DgContainer|DggContainer|self|SpContainer|SpgrContainer|SharedEscher $object)
+    public function __construct(Blip | BSE | BstoreContainer | DgContainer | DggContainer | self | SpContainer | SpgrContainer | SharedEscher $object)
     {
         $this->object = $object;
     }