MewesK / TwigExcelBundle

Twig/Node/XlsRightNode.php

Spacing +4 added lines, -4 removed lines

@@ -28,12 +28,12 @@
     public function compile(Twig_Compiler $compiler)
     {
         $compiler->addDebugInfo($this)
-            ->write('$context[\'phpExcel\']->startAlignment(\'right\');' . PHP_EOL)
+            ->write('$context[\'phpExcel\']->startAlignment(\'right\');'.PHP_EOL)
             ->write("ob_start();\n")
             ->subcompile($this->getNode('body'))
-            ->write('$rightValue = trim(ob_get_clean());' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->endAlignment($rightValue);' . PHP_EOL)
-            ->write('unset($rightValue);' . PHP_EOL);
+            ->write('$rightValue = trim(ob_get_clean());'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->endAlignment($rightValue);'.PHP_EOL)
+            ->write('unset($rightValue);'.PHP_EOL);
     }
 
     /**

Twig/Node/XlsRowNode.php

Spacing +4 added lines, -4 removed lines

@@ -32,12 +32,12 @@
         $compiler->addDebugInfo($this)
             ->write('$context[\'phpExcel\']->setRowIndex(')
             ->subcompile($this->getNode('index'))
-            ->raw(');' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->startRow($context[\'phpExcel\']->getRowIndex());' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->setRowIndex(0);' . PHP_EOL)
+            ->raw(');'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->startRow($context[\'phpExcel\']->getRowIndex());'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->setRowIndex(0);'.PHP_EOL)
             ->subcompile($this->getNode('body'))
             ->addDebugInfo($this)
-            ->write('$context[\'phpExcel\']->endRow();' . PHP_EOL);
+            ->write('$context[\'phpExcel\']->endRow();'.PHP_EOL);
     }
 
     /**

Twig/Node/XlsSheetNode.php

Spacing +5 added lines, -5 removed lines

@@ -33,18 +33,18 @@
         $compiler->addDebugInfo($this)
             ->write('$sheetIndex = ')
             ->subcompile($this->getNode('index'))
-            ->raw(';' . PHP_EOL)
+            ->raw(';'.PHP_EOL)
             ->write('$sheetProperties = ')
             ->subcompile($this->getNode('properties'))
-            ->raw(';' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->startSheet($sheetIndex, $sheetProperties);' . PHP_EOL)
-            ->write('unset($sheetIndex, $sheetProperties);' . PHP_EOL);
+            ->raw(';'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->startSheet($sheetIndex, $sheetProperties);'.PHP_EOL)
+            ->write('unset($sheetIndex, $sheetProperties);'.PHP_EOL);
 
         if ($this->hasNode('body')) {
             $compiler->subcompile($this->getNode('body'));
         }
 
-        $compiler->addDebugInfo($this)->write('$context[\'phpExcel\']->endSheet();' . PHP_EOL);
+        $compiler->addDebugInfo($this)->write('$context[\'phpExcel\']->endSheet();'.PHP_EOL);
     }
 
     /**

Twig/NodeVisitor/SyntaxCheckNodeVisitor.php

Braces +2 added lines, -4 removed lines

@@ -32,12 +32,10 @@
         if (($node instanceof Twig_Node_Block || $node instanceof Twig_Node_Macro) && !$node->hasAttribute('twigExcelBundle') && $this->checkContainsXlsNode($node)) {
             if ($node instanceof Twig_Node_Block) {
                 throw new Twig_Error_Syntax('Block tags do not work together with Twig tags provided by TwigExcelBundle. Please use \'xlsblock\' instead.');
-            }
-            elseif ($node instanceof Twig_Node_Macro) {
+            } elseif ($node instanceof Twig_Node_Macro) {
                 throw new Twig_Error_Syntax('Macro tags do not work together with Twig tags provided by TwigExcelBundle. Please use \'xlsmacro\' instead.');
             }
-        }
-        elseif ($node instanceof XlsNode) {
+        } elseif ($node instanceof XlsNode) {
             /**
              * @var XlsNode $node
              */

Spacing +1 added lines, -1 removed lines

@@ -44,7 +44,7 @@
              */
             try {
                 NodeHelper::checkAllowedParents($node, $this->path);
-            } catch(Twig_Error_Syntax $e) {
+            } catch (Twig_Error_Syntax $e) {
                 // reset path since throwing an error prevents doLeaveNode to be called
                 $this->path = [];
                 throw $e;

Twig/TokenParser/AbstractTokenParser.php

Spacing +2 added lines, -2 removed lines

@@ -20,8 +20,8 @@
      */
     protected function parseBody()
     {
-        $body = $this->parser->subparse(function (Twig_Token $token) {
-            return $token->test('end' . $this->getTag());
+        $body = $this->parser->subparse(function(Twig_Token $token) {
+            return $token->test('end'.$this->getTag());
         },
             true);
         $this->parser->getStream()->expect(Twig_Token::BLOCK_END_TYPE);

Braces +2 added lines, -1 removed lines

@@ -20,7 +20,8 @@
      */
     protected function parseBody()
     {
-        $body = $this->parser->subparse(function (Twig_Token $token) {
+        $body = $this->parser->subparse(function (Twig_Token $token)
+        {
             return $token->test('end' . $this->getTag());
         },
             true);

Wrapper/XlsDrawingWrapper.php

Spacing +20 added lines, -20 removed lines

@@ -55,52 +55,52 @@ 
 
     protected function initializeMappings()
     {
-        $this->mappings['coordinates'] = function ($value) {
+        $this->mappings['coordinates'] = function($value) {
             $this->object->setCoordinates($value);
         };
-        $this->mappings['description'] = function ($value) {
+        $this->mappings['description'] = function($value) {
             $this->object->setDescription($value);
         };
-        $this->mappings['height'] = function ($value) {
+        $this->mappings['height'] = function($value) {
             $this->object->setHeight($value);
         };
-        $this->mappings['name'] = function ($value) {
+        $this->mappings['name'] = function($value) {
             $this->object->setName($value);
         };
-        $this->mappings['offsetX'] = function ($value) {
+        $this->mappings['offsetX'] = function($value) {
             $this->object->setOffsetX($value);
         };
-        $this->mappings['offsetY'] = function ($value) {
+        $this->mappings['offsetY'] = function($value) {
             $this->object->setOffsetY($value);
         };
-        $this->mappings['resizeProportional'] = function ($value) {
+        $this->mappings['resizeProportional'] = function($value) {
             $this->object->setResizeProportional($value);
         };
-        $this->mappings['rotation'] = function ($value) {
+        $this->mappings['rotation'] = function($value) {
             $this->object->setRotation($value);
         };
-        $this->mappings['shadow']['alignment'] = function ($value) {
+        $this->mappings['shadow']['alignment'] = function($value) {
             $this->object->getShadow()->setAlignment($value);
         };
-        $this->mappings['shadow']['alpha'] = function ($value) {
+        $this->mappings['shadow']['alpha'] = function($value) {
             $this->object->getShadow()->setAlpha($value);
         };
-        $this->mappings['shadow']['blurRadius'] = function ($value) {
+        $this->mappings['shadow']['blurRadius'] = function($value) {
             $this->object->getShadow()->setBlurRadius($value);
         };
-        $this->mappings['shadow']['color'] = function ($value) {
+        $this->mappings['shadow']['color'] = function($value) {
             $this->object->getShadow()->getColor()->setRGB($value);
         };
-        $this->mappings['shadow']['direction'] = function ($value) {
+        $this->mappings['shadow']['direction'] = function($value) {
             $this->object->getShadow()->setDirection($value);
         };
-        $this->mappings['shadow']['distance'] = function ($value) {
+        $this->mappings['shadow']['distance'] = function($value) {
             $this->object->getShadow()->setDistance($value);
         };
-        $this->mappings['shadow']['visible'] = function ($value) {
+        $this->mappings['shadow']['visible'] = function($value) {
             $this->object->getShadow()->setVisible($value);
         };
-        $this->mappings['width'] = function ($value) {
+        $this->mappings['width'] = function($value) {
             $this->object->setWidth($value);
         };
     }
@@ -194,21 +194,21 @@ 
     {
         // create temp path
         $pathExtension = pathinfo($path, PATHINFO_EXTENSION);
-        $tempPath = sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'xlsdrawing' . '_' . md5($path) . ($pathExtension ? '.' . $pathExtension : '');
+        $tempPath = sys_get_temp_dir().DIRECTORY_SEPARATOR.'xlsdrawing'.'_'.md5($path).($pathExtension ? '.'.$pathExtension : '');
 
         // create local copy
         if (!file_exists($tempPath)) {
             $data = file_get_contents($path);
             if ($data === false) {
-                throw new \InvalidArgumentException($path . ' does not exist.');
+                throw new \InvalidArgumentException($path.' does not exist.');
             }
             $temp = fopen($tempPath, 'w+');
             if ($temp === false) {
-                throw new \RuntimeException('Cannot open ' . $tempPath);
+                throw new \RuntimeException('Cannot open '.$tempPath);
             }
             fwrite($temp, $data);
             if (fclose($temp) === false) {
-                throw new \RuntimeException('Cannot close ' . $tempPath);
+                throw new \RuntimeException('Cannot close '.$tempPath);
             }
             unset($data, $temp);
         }

Braces +32 added lines, -16 removed lines

@@ -55,52 +55,68 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['coordinates'] = function ($value) {
+        $this->mappings['coordinates'] = function ($value)
+        {
             $this->object->setCoordinates($value);
         };
-        $this->mappings['description'] = function ($value) {
+        $this->mappings['description'] = function ($value)
+        {
             $this->object->setDescription($value);
         };
-        $this->mappings['height'] = function ($value) {
+        $this->mappings['height'] = function ($value)
+        {
             $this->object->setHeight($value);
         };
-        $this->mappings['name'] = function ($value) {
+        $this->mappings['name'] = function ($value)
+        {
             $this->object->setName($value);
         };
-        $this->mappings['offsetX'] = function ($value) {
+        $this->mappings['offsetX'] = function ($value)
+        {
             $this->object->setOffsetX($value);
         };
-        $this->mappings['offsetY'] = function ($value) {
+        $this->mappings['offsetY'] = function ($value)
+        {
             $this->object->setOffsetY($value);
         };
-        $this->mappings['resizeProportional'] = function ($value) {
+        $this->mappings['resizeProportional'] = function ($value)
+        {
             $this->object->setResizeProportional($value);
         };
-        $this->mappings['rotation'] = function ($value) {
+        $this->mappings['rotation'] = function ($value)
+        {
             $this->object->setRotation($value);
         };
-        $this->mappings['shadow']['alignment'] = function ($value) {
+        $this->mappings['shadow']['alignment'] = function ($value)
+        {
             $this->object->getShadow()->setAlignment($value);
         };
-        $this->mappings['shadow']['alpha'] = function ($value) {
+        $this->mappings['shadow']['alpha'] = function ($value)
+        {
             $this->object->getShadow()->setAlpha($value);
         };
-        $this->mappings['shadow']['blurRadius'] = function ($value) {
+        $this->mappings['shadow']['blurRadius'] = function ($value)
+        {
             $this->object->getShadow()->setBlurRadius($value);
         };
-        $this->mappings['shadow']['color'] = function ($value) {
+        $this->mappings['shadow']['color'] = function ($value)
+        {
             $this->object->getShadow()->getColor()->setRGB($value);
         };
-        $this->mappings['shadow']['direction'] = function ($value) {
+        $this->mappings['shadow']['direction'] = function ($value)
+        {
             $this->object->getShadow()->setDirection($value);
         };
-        $this->mappings['shadow']['distance'] = function ($value) {
+        $this->mappings['shadow']['distance'] = function ($value)
+        {
             $this->object->getShadow()->setDistance($value);
         };
-        $this->mappings['shadow']['visible'] = function ($value) {
+        $this->mappings['shadow']['visible'] = function ($value)
+        {
             $this->object->getShadow()->setVisible($value);
         };
-        $this->mappings['width'] = function ($value) {
+        $this->mappings['width'] = function ($value)
+        {
             $this->object->setWidth($value);
         };
     }

Wrapper/XlsHeaderFooterWrapper.php

Spacing +2 added lines, -2 removed lines

@@ -56,10 +56,10 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['scaleWithDocument'] = function ($value) {
+        $this->mappings['scaleWithDocument'] = function($value) {
             $this->object->setScaleWithDocument($value);
         };
-        $this->mappings['alignWithMargins'] = function ($value) {
+        $this->mappings['alignWithMargins'] = function($value) {
             $this->object->setAlignWithMargins($value);
         };
     }

Braces +4 added lines, -2 removed lines

@@ -56,10 +56,12 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['scaleWithDocument'] = function ($value) {
+        $this->mappings['scaleWithDocument'] = function ($value)
+        {
             $this->object->setScaleWithDocument($value);
         };
-        $this->mappings['alignWithMargins'] = function ($value) {
+        $this->mappings['alignWithMargins'] = function ($value)
+        {
             $this->object->setAlignWithMargins($value);
         };
     }

Twig/Node/XlsDocumentNode.php

Spacing +8 added lines, -8 removed lines

@@ -45,16 +45,16 @@
         $compiler->addDebugInfo($this)
             ->write('$documentProperties = ')
             ->subcompile($this->getNode('properties'))
-            ->raw(';' . PHP_EOL)
-            ->write('$context[\'phpExcel\'] = new MewesK\TwigExcelBundle\Wrapper\PhpExcelWrapper($context, $this->getEnvironment());' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->startDocument($documentProperties);' . PHP_EOL)
-            ->write('unset($documentProperties);' . PHP_EOL)
+            ->raw(';'.PHP_EOL)
+            ->write('$context[\'phpExcel\'] = new MewesK\TwigExcelBundle\Wrapper\PhpExcelWrapper($context, $this->getEnvironment());'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->startDocument($documentProperties);'.PHP_EOL)
+            ->write('unset($documentProperties);'.PHP_EOL)
             ->subcompile($this->getNode('body'))
             ->addDebugInfo($this)
-            ->write('$context[\'phpExcel\']->endDocument(' .
-                ($this->preCalculateFormulas ? 'true' : 'false') . ', ' .
-                ($this->diskCachingDirectory ? '\'' . $this->diskCachingDirectory . '\'' : 'null') . ');' . PHP_EOL)
-            ->write('unset($context[\'phpExcel\']);' . PHP_EOL);
+            ->write('$context[\'phpExcel\']->endDocument('.
+                ($this->preCalculateFormulas ? 'true' : 'false').', '.
+                ($this->diskCachingDirectory ? '\''.$this->diskCachingDirectory.'\'' : 'null').');'.PHP_EOL)
+            ->write('unset($context[\'phpExcel\']);'.PHP_EOL);
     }
 
     /**

Wrapper/XlsSheetWrapper.php

Spacing +56 added lines, -56 removed lines

@@ -79,167 +79,167 @@ 
     protected function initializeMappings()
     {
         $this->mappings['columnDimension']['__multi'] = true;
-        $this->mappings['columnDimension']['__object'] = function ($key = 'default') {
+        $this->mappings['columnDimension']['__object'] = function($key = 'default') {
             return $key === 'default' ? $this->object->getDefaultColumnDimension() : $this->object->getColumnDimension($key);
         };
-        $this->mappings['columnDimension']['autoSize'] = function ($key, $value) {
+        $this->mappings['columnDimension']['autoSize'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setAutoSize($value);
         };
-        $this->mappings['columnDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['columnDimension']['collapsed'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['columnIndex'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setColumnIndex($value);
         };
-        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['columnDimension']['outlineLevel'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['columnDimension']['visible'] = function ($key, $value) {
+        $this->mappings['columnDimension']['visible'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['columnDimension']['width'] = function ($key, $value) {
+        $this->mappings['columnDimension']['width'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setWidth($value);
         };
-        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['xfIndex'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['pageMargins']['top'] = function ($value) {
+        $this->mappings['pageMargins']['top'] = function($value) {
             $this->object->getPageMargins()->setTop($value);
         };
-        $this->mappings['pageMargins']['bottom'] = function ($value) {
+        $this->mappings['pageMargins']['bottom'] = function($value) {
             $this->object->getPageMargins()->setBottom($value);
         };
-        $this->mappings['pageMargins']['left'] = function ($value) {
+        $this->mappings['pageMargins']['left'] = function($value) {
             $this->object->getPageMargins()->setLeft($value);
         };
-        $this->mappings['pageMargins']['right'] = function ($value) {
+        $this->mappings['pageMargins']['right'] = function($value) {
             $this->object->getPageMargins()->setRight($value);
         };
-        $this->mappings['pageMargins']['header'] = function ($value) {
+        $this->mappings['pageMargins']['header'] = function($value) {
             $this->object->getPageMargins()->setHeader($value);
         };
-        $this->mappings['pageMargins']['footer'] = function ($value) {
+        $this->mappings['pageMargins']['footer'] = function($value) {
             $this->object->getPageMargins()->setFooter($value);
         };
-        $this->mappings['pageSetup']['fitToHeight'] = function ($value) {
+        $this->mappings['pageSetup']['fitToHeight'] = function($value) {
             $this->object->getPageSetup()->setFitToHeight($value);
         };
-        $this->mappings['pageSetup']['fitToPage'] = function ($value) {
+        $this->mappings['pageSetup']['fitToPage'] = function($value) {
             $this->object->getPageSetup()->setFitToPage($value);
         };
-        $this->mappings['pageSetup']['fitToWidth'] = function ($value) {
+        $this->mappings['pageSetup']['fitToWidth'] = function($value) {
             $this->object->getPageSetup()->setFitToWidth($value);
         };
-        $this->mappings['pageSetup']['horizontalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['horizontalCentered'] = function($value) {
             $this->object->getPageSetup()->setHorizontalCentered($value);
         };
-        $this->mappings['pageSetup']['orientation'] = function ($value) {
+        $this->mappings['pageSetup']['orientation'] = function($value) {
             $this->object->getPageSetup()->setOrientation($value);
         };
-        $this->mappings['pageSetup']['paperSize'] = function ($value) {
+        $this->mappings['pageSetup']['paperSize'] = function($value) {
             $this->object->getPageSetup()->setPaperSize($value);
         };
-        $this->mappings['pageSetup']['printArea'] = function ($value) {
+        $this->mappings['pageSetup']['printArea'] = function($value) {
             $this->object->getPageSetup()->setPrintArea($value);
         };
-        $this->mappings['pageSetup']['scale'] = function ($value) {
+        $this->mappings['pageSetup']['scale'] = function($value) {
             $this->object->getPageSetup()->setScale($value);
         };
-        $this->mappings['pageSetup']['verticalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['verticalCentered'] = function($value) {
             $this->object->getPageSetup()->setVerticalCentered($value);
         };
-        $this->mappings['printGridlines'] = function ($value) {
+        $this->mappings['printGridlines'] = function($value) {
             $this->object->setPrintGridlines($value);
         };
-        $this->mappings['protection']['autoFilter'] = function ($value) {
+        $this->mappings['protection']['autoFilter'] = function($value) {
             $this->object->getProtection()->setAutoFilter($value);
         };
-        $this->mappings['protection']['deleteColumns'] = function ($value) {
+        $this->mappings['protection']['deleteColumns'] = function($value) {
             $this->object->getProtection()->setDeleteColumns($value);
         };
-        $this->mappings['protection']['deleteRows'] = function ($value) {
+        $this->mappings['protection']['deleteRows'] = function($value) {
             $this->object->getProtection()->setDeleteRows($value);
         };
-        $this->mappings['protection']['formatCells'] = function ($value) {
+        $this->mappings['protection']['formatCells'] = function($value) {
             $this->object->getProtection()->setFormatCells($value);
         };
-        $this->mappings['protection']['formatColumns'] = function ($value) {
+        $this->mappings['protection']['formatColumns'] = function($value) {
             $this->object->getProtection()->setFormatColumns($value);
         };
-        $this->mappings['protection']['formatRows'] = function ($value) {
+        $this->mappings['protection']['formatRows'] = function($value) {
             $this->object->getProtection()->setFormatRows($value);
         };
-        $this->mappings['protection']['insertColumns'] = function ($value) {
+        $this->mappings['protection']['insertColumns'] = function($value) {
             $this->object->getProtection()->setInsertColumns($value);
         };
-        $this->mappings['protection']['insertHyperlinks'] = function ($value) {
+        $this->mappings['protection']['insertHyperlinks'] = function($value) {
             $this->object->getProtection()->setInsertHyperlinks($value);
         };
-        $this->mappings['protection']['insertRows'] = function ($value) {
+        $this->mappings['protection']['insertRows'] = function($value) {
             $this->object->getProtection()->setInsertRows($value);
         };
-        $this->mappings['protection']['objects'] = function ($value) {
+        $this->mappings['protection']['objects'] = function($value) {
             $this->object->getProtection()->setObjects($value);
         };
-        $this->mappings['protection']['password'] = function ($value) {
+        $this->mappings['protection']['password'] = function($value) {
             $this->object->getProtection()->setPassword($value);
         };
-        $this->mappings['protection']['pivotTables'] = function ($value) {
+        $this->mappings['protection']['pivotTables'] = function($value) {
             $this->object->getProtection()->setPivotTables($value);
         };
-        $this->mappings['protection']['scenarios'] = function ($value) {
+        $this->mappings['protection']['scenarios'] = function($value) {
             $this->object->getProtection()->setScenarios($value);
         };
-        $this->mappings['protection']['selectLockedCells'] = function ($value) {
+        $this->mappings['protection']['selectLockedCells'] = function($value) {
             $this->object->getProtection()->setSelectLockedCells($value);
         };
-        $this->mappings['protection']['selectUnlockedCells'] = function ($value) {
+        $this->mappings['protection']['selectUnlockedCells'] = function($value) {
             $this->object->getProtection()->setSelectUnlockedCells($value);
         };
-        $this->mappings['protection']['sheet'] = function ($value) {
+        $this->mappings['protection']['sheet'] = function($value) {
             $this->object->getProtection()->setSheet($value);
         };
-        $this->mappings['protection']['sort'] = function ($value) {
+        $this->mappings['protection']['sort'] = function($value) {
             $this->object->getProtection()->setSort($value);
         };
-        $this->mappings['rightToLeft'] = function ($value) {
+        $this->mappings['rightToLeft'] = function($value) {
             $this->object->setRightToLeft($value);
         };
         $this->mappings['rowDimension']['__multi'] = true;
-        $this->mappings['rowDimension']['__object'] = function ($key) {
+        $this->mappings['rowDimension']['__object'] = function($key) {
             return $key === 'default' ? $this->object->getDefaultRowDimension() : $this->object->getRowDimension($key);
         };
-        $this->mappings['rowDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['rowDimension']['collapsed'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['rowDimension']['outlineLevel'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowHeight'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setRowHeight($value);
         };
-        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowIndex'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setRowIndex($value);
         };
-        $this->mappings['rowDimension']['visible'] = function ($key, $value) {
+        $this->mappings['rowDimension']['visible'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['xfIndex'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['zeroHeight'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setZeroHeight($value);
         };
-        $this->mappings['sheetState'] = function ($value) {
+        $this->mappings['sheetState'] = function($value) {
             $this->object->setSheetState($value);
         };
-        $this->mappings['showGridlines'] = function ($value) {
+        $this->mappings['showGridlines'] = function($value) {
             $this->object->setShowGridlines($value);
         };
-        $this->mappings['tabColor'] = function ($value) {
+        $this->mappings['tabColor'] = function($value) {
             $this->object->getTabColor()->setRGB($value);
         };
-        $this->mappings['zoomScale'] = function ($value) {
+        $this->mappings['zoomScale'] = function($value) {
             $this->object->getSheetView()->setZoomScale($value);
         };
     }
@@ -251,7 +251,7 @@ 
      */
     public function start($index, array $properties = null)
     {
-        if (is_int($index) && $index <$this->documentWrapper->getObject()->getSheetCount()) {
+        if (is_int($index) && $index < $this->documentWrapper->getObject()->getSheetCount()) {
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex($index);
         } elseif (is_string($index)) {
             if (!$this->documentWrapper->getObject()->sheetNameExists($index)) {
@@ -259,7 +259,7 @@ 
                 $this->documentWrapper->getObject()->createSheet()->setTitle($index);
             }
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
-        }  else {
+        } else {
             // create new sheet without a name
             $this->documentWrapper->getObject()->createSheet();
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);

Braces +109 added lines, -55 removed lines

@@ -79,167 +79,221 @@ 
     protected function initializeMappings()
     {
         $this->mappings['columnDimension']['__multi'] = true;
-        $this->mappings['columnDimension']['__object'] = function ($key = 'default') {
+        $this->mappings['columnDimension']['__object'] = function ($key = 'default')
+        {
             return $key === 'default' ? $this->object->getDefaultColumnDimension() : $this->object->getColumnDimension($key);
         };
-        $this->mappings['columnDimension']['autoSize'] = function ($key, $value) {
+        $this->mappings['columnDimension']['autoSize'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setAutoSize($value);
         };
-        $this->mappings['columnDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['columnDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setColumnIndex($value);
         };
-        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['columnDimension']['visible'] = function ($key, $value) {
+        $this->mappings['columnDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['columnDimension']['width'] = function ($key, $value) {
+        $this->mappings['columnDimension']['width'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setWidth($value);
         };
-        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['pageMargins']['top'] = function ($value) {
+        $this->mappings['pageMargins']['top'] = function ($value)
+        {
             $this->object->getPageMargins()->setTop($value);
         };
-        $this->mappings['pageMargins']['bottom'] = function ($value) {
+        $this->mappings['pageMargins']['bottom'] = function ($value)
+        {
             $this->object->getPageMargins()->setBottom($value);
         };
-        $this->mappings['pageMargins']['left'] = function ($value) {
+        $this->mappings['pageMargins']['left'] = function ($value)
+        {
             $this->object->getPageMargins()->setLeft($value);
         };
-        $this->mappings['pageMargins']['right'] = function ($value) {
+        $this->mappings['pageMargins']['right'] = function ($value)
+        {
             $this->object->getPageMargins()->setRight($value);
         };
-        $this->mappings['pageMargins']['header'] = function ($value) {
+        $this->mappings['pageMargins']['header'] = function ($value)
+        {
             $this->object->getPageMargins()->setHeader($value);
         };
-        $this->mappings['pageMargins']['footer'] = function ($value) {
+        $this->mappings['pageMargins']['footer'] = function ($value)
+        {
             $this->object->getPageMargins()->setFooter($value);
         };
-        $this->mappings['pageSetup']['fitToHeight'] = function ($value) {
+        $this->mappings['pageSetup']['fitToHeight'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToHeight($value);
         };
-        $this->mappings['pageSetup']['fitToPage'] = function ($value) {
+        $this->mappings['pageSetup']['fitToPage'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToPage($value);
         };
-        $this->mappings['pageSetup']['fitToWidth'] = function ($value) {
+        $this->mappings['pageSetup']['fitToWidth'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToWidth($value);
         };
-        $this->mappings['pageSetup']['horizontalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['horizontalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setHorizontalCentered($value);
         };
-        $this->mappings['pageSetup']['orientation'] = function ($value) {
+        $this->mappings['pageSetup']['orientation'] = function ($value)
+        {
             $this->object->getPageSetup()->setOrientation($value);
         };
-        $this->mappings['pageSetup']['paperSize'] = function ($value) {
+        $this->mappings['pageSetup']['paperSize'] = function ($value)
+        {
             $this->object->getPageSetup()->setPaperSize($value);
         };
-        $this->mappings['pageSetup']['printArea'] = function ($value) {
+        $this->mappings['pageSetup']['printArea'] = function ($value)
+        {
             $this->object->getPageSetup()->setPrintArea($value);
         };
-        $this->mappings['pageSetup']['scale'] = function ($value) {
+        $this->mappings['pageSetup']['scale'] = function ($value)
+        {
             $this->object->getPageSetup()->setScale($value);
         };
-        $this->mappings['pageSetup']['verticalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['verticalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setVerticalCentered($value);
         };
-        $this->mappings['printGridlines'] = function ($value) {
+        $this->mappings['printGridlines'] = function ($value)
+        {
             $this->object->setPrintGridlines($value);
         };
-        $this->mappings['protection']['autoFilter'] = function ($value) {
+        $this->mappings['protection']['autoFilter'] = function ($value)
+        {
             $this->object->getProtection()->setAutoFilter($value);
         };
-        $this->mappings['protection']['deleteColumns'] = function ($value) {
+        $this->mappings['protection']['deleteColumns'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteColumns($value);
         };
-        $this->mappings['protection']['deleteRows'] = function ($value) {
+        $this->mappings['protection']['deleteRows'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteRows($value);
         };
-        $this->mappings['protection']['formatCells'] = function ($value) {
+        $this->mappings['protection']['formatCells'] = function ($value)
+        {
             $this->object->getProtection()->setFormatCells($value);
         };
-        $this->mappings['protection']['formatColumns'] = function ($value) {
+        $this->mappings['protection']['formatColumns'] = function ($value)
+        {
             $this->object->getProtection()->setFormatColumns($value);
         };
-        $this->mappings['protection']['formatRows'] = function ($value) {
+        $this->mappings['protection']['formatRows'] = function ($value)
+        {
             $this->object->getProtection()->setFormatRows($value);
         };
-        $this->mappings['protection']['insertColumns'] = function ($value) {
+        $this->mappings['protection']['insertColumns'] = function ($value)
+        {
             $this->object->getProtection()->setInsertColumns($value);
         };
-        $this->mappings['protection']['insertHyperlinks'] = function ($value) {
+        $this->mappings['protection']['insertHyperlinks'] = function ($value)
+        {
             $this->object->getProtection()->setInsertHyperlinks($value);
         };
-        $this->mappings['protection']['insertRows'] = function ($value) {
+        $this->mappings['protection']['insertRows'] = function ($value)
+        {
             $this->object->getProtection()->setInsertRows($value);
         };
-        $this->mappings['protection']['objects'] = function ($value) {
+        $this->mappings['protection']['objects'] = function ($value)
+        {
             $this->object->getProtection()->setObjects($value);
         };
-        $this->mappings['protection']['password'] = function ($value) {
+        $this->mappings['protection']['password'] = function ($value)
+        {
             $this->object->getProtection()->setPassword($value);
         };
-        $this->mappings['protection']['pivotTables'] = function ($value) {
+        $this->mappings['protection']['pivotTables'] = function ($value)
+        {
             $this->object->getProtection()->setPivotTables($value);
         };
-        $this->mappings['protection']['scenarios'] = function ($value) {
+        $this->mappings['protection']['scenarios'] = function ($value)
+        {
             $this->object->getProtection()->setScenarios($value);
         };
-        $this->mappings['protection']['selectLockedCells'] = function ($value) {
+        $this->mappings['protection']['selectLockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectLockedCells($value);
         };
-        $this->mappings['protection']['selectUnlockedCells'] = function ($value) {
+        $this->mappings['protection']['selectUnlockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectUnlockedCells($value);
         };
-        $this->mappings['protection']['sheet'] = function ($value) {
+        $this->mappings['protection']['sheet'] = function ($value)
+        {
             $this->object->getProtection()->setSheet($value);
         };
-        $this->mappings['protection']['sort'] = function ($value) {
+        $this->mappings['protection']['sort'] = function ($value)
+        {
             $this->object->getProtection()->setSort($value);
         };
-        $this->mappings['rightToLeft'] = function ($value) {
+        $this->mappings['rightToLeft'] = function ($value)
+        {
             $this->object->setRightToLeft($value);
         };
         $this->mappings['rowDimension']['__multi'] = true;
-        $this->mappings['rowDimension']['__object'] = function ($key) {
+        $this->mappings['rowDimension']['__object'] = function ($key)
+        {
             return $key === 'default' ? $this->object->getDefaultRowDimension() : $this->object->getRowDimension($key);
         };
-        $this->mappings['rowDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['rowDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowHeight($value);
         };
-        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowIndex($value);
         };
-        $this->mappings['rowDimension']['visible'] = function ($key, $value) {
+        $this->mappings['rowDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setZeroHeight($value);
         };
-        $this->mappings['sheetState'] = function ($value) {
+        $this->mappings['sheetState'] = function ($value)
+        {
             $this->object->setSheetState($value);
         };
-        $this->mappings['showGridlines'] = function ($value) {
+        $this->mappings['showGridlines'] = function ($value)
+        {
             $this->object->setShowGridlines($value);
         };
-        $this->mappings['tabColor'] = function ($value) {
+        $this->mappings['tabColor'] = function ($value)
+        {
             $this->object->getTabColor()->setRGB($value);
         };
-        $this->mappings['zoomScale'] = function ($value) {
+        $this->mappings['zoomScale'] = function ($value)
+        {
             $this->object->getSheetView()->setZoomScale($value);
         };
     }
@@ -259,7 +313,7 @@ 
                 $this->documentWrapper->getObject()->createSheet()->setTitle($index);
             }
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
-        }  else {
+        } else {
             // create new sheet without a name
             $this->documentWrapper->getObject()->createSheet();
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);