PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Worksheet/BaseDrawing.php

Spacing +1 added lines, -2 removed lines

@@ -137,8 +137,7 @@
         $this->rotation = 0;
         $this->shadow = new Drawing\Shadow();
 
-        // Set image index
-        ++self::$imageCounter;
+        // Set image index++self::$imageCounter;
         $this->imageIndex = self::$imageCounter;
     }
 

tests/data/Calculation/DateTime/DAY.php

Spacing +20 added lines, -20 removed lines

@@ -4,53 +4,53 @@
 
 return [
     [
-        19,         // Result for Excel
-        19,         // Result for OpenOffice
+        19, // Result for Excel
+        19, // Result for OpenOffice
         22269,
     ],
     [
-        1,          // Result for Excel
-        1,          // Result for OpenOffice
+        1, // Result for Excel
+        1, // Result for OpenOffice
         30348,
     ],
     [
-        10,         // Result for Excel
-        10,         // Result for OpenOffice
+        10, // Result for Excel
+        10, // Result for OpenOffice
         30843,
     ],
     [
-        11,         // Result for Excel
-        11,         // Result for OpenOffice
+        11, // Result for Excel
+        11, // Result for OpenOffice
         '11-Nov-1918',
     ],
     [
-        28,         // Result for Excel
-        28,         // Result for OpenOffice
+        28, // Result for Excel
+        28, // Result for OpenOffice
         '28-Feb-1904',
     ],
     [
-        '#VALUE!',  // Result for Excel
-        '#VALUE!',  // Result for OpenOffice
+        '#VALUE!', // Result for Excel
+        '#VALUE!', // Result for OpenOffice
         'Invalid',
     ],
     [
-        '#NUM!',  // Result for Excel
-        29,       // Result for OpenOffice
+        '#NUM!', // Result for Excel
+        29, // Result for OpenOffice
         -1,
     ],
     [
-        1,         // Result for Excel
-        31,        // Result for OpenOffice
+        1, // Result for Excel
+        31, // Result for OpenOffice
         1,
     ],
     [
-        0,         // Result for Excel
-        30,        // Result for OpenOffice
+        0, // Result for Excel
+        30, // Result for OpenOffice
         0.5,
     ],
     [
-        0,         // Result for Excel
-        30,        // Result for OpenOffice
+        0, // Result for Excel
+        30, // Result for OpenOffice
         0,
     ],
 ];

src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php

Spacing +1 added lines, -1 removed lines

@@ -491,7 +491,7 @@
                         $objWriter->writeAttribute('text', $conditional->getText());
                     }
 
-                    if( $conditional->getStopIfTrue() == true ) {
+                    if ($conditional->getStopIfTrue() == true) {
                         $objWriter->writeAttribute('stopIfTrue', '1');
                     }
 

tests/PhpSpreadsheetTests/Functional/ConditionalStopIfTrue.php

Indentation +36 added lines, -36 removed lines

@@ -6,7 +6,7 @@ 
 
 class ConditionalStopIfTrue extends AbstractFunctional
 {
-	const
+    const
         COLOR_GREEN             = 'FF99FF66',
         COLOR_RED               = 'FFFF5050'
     ;
@@ -25,50 +25,50 @@ 
      */
     public function testConditionalStopIfTrue($format)
     {
-		$pCoordinate = 'A1:A3';
+        $pCoordinate = 'A1:A3';
 		
-		// if blank cell -> no styling
-		$condition0 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
-		$condition0->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_EXPRESSION);
-		$condition0->addCondition('LEN(TRIM(A1))=0');
-		$condition0->setStopIfTrue(true); // ! stop here
+        // if blank cell -> no styling
+        $condition0 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
+        $condition0->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_EXPRESSION);
+        $condition0->addCondition('LEN(TRIM(A1))=0');
+        $condition0->setStopIfTrue(true); // ! stop here
 
-		// if value below 0.6 (matches also blank cells!) -> red background
-		$condition1 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
-		$condition1->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
-		$condition1->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN);
-		$condition1->addCondition(0.6);
-		$condition1->getStyle()->getFill()
-			->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
-			->getEndColor()->setARGB(self::COLOR_RED);
+        // if value below 0.6 (matches also blank cells!) -> red background
+        $condition1 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
+        $condition1->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
+        $condition1->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN);
+        $condition1->addCondition(0.6);
+        $condition1->getStyle()->getFill()
+            ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
+            ->getEndColor()->setARGB(self::COLOR_RED);
 		
-		// if value above 0.6 -> green background
-		$condition2 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
-		$condition2->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
-		$condition2->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHAN);
-		$condition2->addCondition(0.6);
-		$condition2->getStyle()->getFill()
-			->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
-			->getEndColor()->setARGB(self::COLOR_GREEN);
+        // if value above 0.6 -> green background
+        $condition2 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
+        $condition2->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
+        $condition2->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHAN);
+        $condition2->addCondition(0.6);
+        $condition2->getStyle()->getFill()
+            ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
+            ->getEndColor()->setARGB(self::COLOR_GREEN);
 
         $spreadsheet = new Spreadsheet();
         $spreadsheet->getActiveSheet()->getCell('A1')->setValue(0.7);
-		$spreadsheet->getActiveSheet()->getCell('A2')->setValue('');
-		$spreadsheet->getActiveSheet()->getCell('A3')->setValue(0.4);
+        $spreadsheet->getActiveSheet()->getCell('A2')->setValue('');
+        $spreadsheet->getActiveSheet()->getCell('A3')->setValue(0.4);
 
-		// put all three conditions in sheet
-		$conditionalStyles = [];
-		array_push($conditionalStyles, $condition0);
-		array_push($conditionalStyles, $condition1);
-		array_push($conditionalStyles, $condition2);
-		$spreadsheet->getActiveSheet()->setConditionalStyles($pCoordinate, $conditionalStyles);
+        // put all three conditions in sheet
+        $conditionalStyles = [];
+        array_push($conditionalStyles, $condition0);
+        array_push($conditionalStyles, $condition1);
+        array_push($conditionalStyles, $condition2);
+        $spreadsheet->getActiveSheet()->setConditionalStyles($pCoordinate, $conditionalStyles);
 
         $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, $format);
 		
-		// see if we successfully written "StopIfTrue"
-		$newConditionalStyles = $reloadedSpreadsheet->getActiveSheet()->getConditionalStyles($pCoordinate);
-		self::assertTrue($newConditionalStyles[0]->getStopIfTrue(), 'StopIfTrue should be set (=true) on first condition');
-		self::assertFalse($newConditionalStyles[1]->getStopIfTrue(), 'StopIfTrue should not be set (=false) on second condition');
-		self::assertFalse($newConditionalStyles[2]->getStopIfTrue(), 'StopIfTrue should not be set (=false) on third condition');
+        // see if we successfully written "StopIfTrue"
+        $newConditionalStyles = $reloadedSpreadsheet->getActiveSheet()->getConditionalStyles($pCoordinate);
+        self::assertTrue($newConditionalStyles[0]->getStopIfTrue(), 'StopIfTrue should be set (=true) on first condition');
+        self::assertFalse($newConditionalStyles[1]->getStopIfTrue(), 'StopIfTrue should not be set (=false) on second condition');
+        self::assertFalse($newConditionalStyles[2]->getStopIfTrue(), 'StopIfTrue should not be set (=false) on third condition');
     }
 }