Style.php

Go to the documentation of this file.

<?php
if (!defined('PHPEXCEL_ROOT')) {
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../');
}

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Color.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Font.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Fill.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Borders.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Alignment.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/NumberFormat.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Conditional.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Style/Protection.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/IComparable.php';

class PHPExcel_Style implements PHPExcel_IComparable
{
        private $_font;
        
        private $_fill;

        private $_borders;
        
        private $_alignment;
        
        private $_numberFormat;
        
        private $_conditionalStyles;
        
        private $_protection;

        private $_isSupervisor;

        private $_parent;

        private $_index;

    public function __construct($isSupervisor = false)
    {
        // Supervisor?
                $this->_isSupervisor = $isSupervisor;

                // Initialise values
        $this->_conditionalStyles       = array();
                $this->_font                            = new PHPExcel_Style_Font($isSupervisor);
                $this->_fill                            = new PHPExcel_Style_Fill($isSupervisor);
                $this->_borders                         = new PHPExcel_Style_Borders($isSupervisor);
                $this->_alignment                       = new PHPExcel_Style_Alignment($isSupervisor);
                $this->_numberFormat            = new PHPExcel_Style_NumberFormat($isSupervisor);
                $this->_protection                      = new PHPExcel_Style_Protection($isSupervisor);

                // bind parent if we are a supervisor
                if ($isSupervisor) {
                        $this->_font->bindParent($this);
                        $this->_fill->bindParent($this);
                        $this->_borders->bindParent($this);
                        $this->_alignment->bindParent($this);
                        $this->_numberFormat->bindParent($this);
                        $this->_protection->bindParent($this);
                }
    }

        public function bindParent($parent)
        {
                $this->_parent = $parent;
                return $this;
        }
        
        public function getIsSupervisor()
        {
                return $this->_isSupervisor;
        }

        public function getSharedComponent()
        {
                $activeSheet = $this->getActiveSheet();
                $selectedCell = $this->getXActiveCell(); // e.g. 'A1'

                if ($activeSheet->cellExists($selectedCell)) {
                        $cell = $activeSheet->getCell($selectedCell);
                        $xfIndex = $cell->getXfIndex();
                } else {
                        $xfIndex = 0;
                }

                $activeStyle = $this->_parent->getCellXfByIndex($xfIndex);
                return $activeStyle;
        }

        public function getActiveSheet()
        {
                return $this->_parent->getActiveSheet();
        }

        public function getXSelectedCells()
        {
                return $this->_parent->getActiveSheet()->getXSelectedCells();
        }

        public function getXActiveCell()
        {
                return $this->_parent->getActiveSheet()->getXActiveCell();
        }

        public function getParent()
        {
                return $this->_parent;
        }

        public function applyFromArray($pStyles = null, $pAdvanced = true) {
                if (is_array($pStyles)) {
                        if ($this->_isSupervisor) {

                                $pRange = $this->getXSelectedCells();

                                if (is_array($pStyles)) {
                                        // Uppercase coordinate
                                        $pRange = strtoupper($pRange);

                                        // Is it a cell range or a single cell?
                                        $rangeA         = '';
                                        $rangeB         = '';
                                        if (strpos($pRange, ':') === false) {
                                                $rangeA = $pRange;
                                                $rangeB = $pRange;
                                        } else {
                                                list($rangeA, $rangeB) = explode(':', $pRange);
                                        }

                                        // Calculate range outer borders
                                        $rangeStart = PHPExcel_Cell::coordinateFromString($rangeA);
                                        $rangeEnd       = PHPExcel_Cell::coordinateFromString($rangeB);

                                        // Translate column into index
                                        $rangeStart[0]  = PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1;
                                        $rangeEnd[0]    = PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1;

                                        // Make sure we can loop upwards on rows and columns
                                        if ($rangeStart[0] > $rangeEnd[0] && $rangeStart[1] > $rangeEnd[1]) {
                                                $tmp = $rangeStart;
                                                $rangeStart = $rangeEnd;
                                                $rangeEnd = $tmp;
                                        }

                                        // Advanced mode
                                        if ($pAdvanced && isset($pStyles['borders'])) {

                                                // 'allborders' is a shorthand property for 'outline' and 'inside' and
                                                //              it applies to components that have not been set explicitly
                                                if (isset($pStyles['borders']['allborders'])) {
                                                        foreach (array('outline', 'inside') as $component) {
                                                                if (!isset($pStyles['borders'][$component])) {
                                                                        $pStyles['borders'][$component] = $pStyles['borders']['allborders'];
                                                                }
                                                        }
                                                        unset($pStyles['borders']['allborders']); // not needed any more
                                                }

                                                // 'outline' is a shorthand property for 'top', 'right', 'bottom', 'left'
                                                //              it applies to components that have not been set explicitly
                                                if (isset($pStyles['borders']['outline'])) {
                                                        foreach (array('top', 'right', 'bottom', 'left') as $component) {
                                                                if (!isset($pStyles['borders'][$component])) {
                                                                        $pStyles['borders'][$component] = $pStyles['borders']['outline'];
                                                                }
                                                        }
                                                        unset($pStyles['borders']['outline']); // not needed any more
                                                }

                                                // 'inside' is a shorthand property for 'vertical' and 'horizontal'
                                                //              it applies to components that have not been set explicitly
                                                if (isset($pStyles['borders']['inside'])) {
                                                        foreach (array('vertical', 'horizontal') as $component) {
                                                                if (!isset($pStyles['borders'][$component])) {
                                                                        $pStyles['borders'][$component] = $pStyles['borders']['inside'];
                                                                }
                                                        }
                                                        unset($pStyles['borders']['inside']); // not needed any more
                                                }

                                                // width and height characteristics of selection, 1, 2, or 3 (for 3 or more)
                                                $xMax = min($rangeEnd[0] - $rangeStart[0] + 1, 3);
                                                $yMax = min($rangeEnd[1] - $rangeStart[1] + 1, 3);

                                                // loop through up to 3 x 3 = 9 regions
                                                for ($x = 1; $x <= $xMax; ++$x) {
                                                        // start column index for region
                                                        $colStart = ($x == 3) ? 
                                                                PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0])
                                                                        : PHPExcel_Cell::stringFromColumnIndex($rangeStart[0] + $x - 1);

                                                        // end column index for region
                                                        $colEnd = ($x == 1) ?
                                                                PHPExcel_Cell::stringFromColumnIndex($rangeStart[0])
                                                                        : PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0] - $xMax + $x);

                                                        for ($y = 1; $y <= $yMax; ++$y) {

                                                                // which edges are touching the region
                                                                $edges = array();

                                                                // are we at left edge
                                                                if ($x == 1) {
                                                                        $edges[] = 'left';
                                                                }

                                                                // are we at right edge
                                                                if ($x == $xMax) {
                                                                        $edges[] = 'right';
                                                                }

                                                                // are we at top edge?
                                                                if ($y == 1) {
                                                                        $edges[] = 'top';
                                                                }

                                                                // are we at bottom edge?
                                                                if ($y == $yMax) {
                                                                        $edges[] = 'bottom';
                                                                }

                                                                // start row index for region
                                                                $rowStart = ($y == 3) ?
                                                                        $rangeEnd[1] : $rangeStart[1] + $y - 1;

                                                                // end row index for region
                                                                $rowEnd = ($y == 1) ?
                                                                        $rangeStart[1] : $rangeEnd[1] - $yMax + $y;

                                                                // build range for region
                                                                $range = $colStart . $rowStart . ':' . $colEnd . $rowEnd;
                                                                
                                                                // retrieve relevant style array for region
                                                                $regionStyles = $pStyles;
                                                                unset($regionStyles['borders']['inside']);

                                                                // what are the inner edges of the region when looking at the selection
                                                                $innerEdges = array_diff( array('top', 'right', 'bottom', 'left'), $edges );

                                                                // inner edges that are not touching the region should take the 'inside' border properties if they have been set
                                                                foreach ($innerEdges as $innerEdge) {
                                                                        switch ($innerEdge) {
                                                                                case 'top':
                                                                                case 'bottom':
                                                                                        // should pick up 'horizontal' border property if set
                                                                                        if (isset($pStyles['borders']['horizontal'])) {
                                                                                                $regionStyles['borders'][$innerEdge] = $pStyles['borders']['horizontal'];
                                                                                        } else {
                                                                                                unset($regionStyles['borders'][$innerEdge]);
                                                                                        }
                                                                                        break;
                                                                                case 'left':
                                                                                case 'right':
                                                                                        // should pick up 'vertical' border property if set
                                                                                        if (isset($pStyles['borders']['vertical'])) {
                                                                                                $regionStyles['borders'][$innerEdge] = $pStyles['borders']['vertical'];
                                                                                        } else {
                                                                                                unset($regionStyles['borders'][$innerEdge]);
                                                                                        }
                                                                                        break;
                                                                        }
                                                                }

                                                                // apply region style to region by calling applyFromArray() in simple mode
                                                                $this->getActiveSheet()->getStyle($range)->applyFromArray($regionStyles, false);
                                                        }
                                                }
                                                return;
                                        }

                                        // Simple mode
                                        
                                        // First loop through cells to find out which styles are affected by this operation
                                        $oldXfIndexes = array();
                                        for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {
                                                for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {
                                                        $oldXfIndexes[$this->getActiveSheet()->getCellByColumnAndRow($col, $row)->getXfIndex()] = true;
                                                }
                                        }

                                        // clone each of the affected styles, apply the style arrray, and add the new styles to the workbook
                                        $workbook = $this->getActiveSheet()->getParent();
                                        foreach ($oldXfIndexes as $oldXfIndex => $dummy) {
                                                $style = $workbook->getCellXfByIndex($oldXfIndex);
                                                $newStyle = clone $style;
                                                $newStyle->applyFromArray($pStyles);
                                                
                                                if ($existingStyle = $workbook->getCellXfByHashCode($newStyle->getHashCode())) {
                                                        // there is already such cell Xf in our collection
                                                        $newXfIndexes[$oldXfIndex] = $existingStyle->getIndex();
                                                } else {
                                                        // we don't have such a cell Xf, need to add
                                                        $workbook->addCellXf($newStyle);
                                                        $newXfIndexes[$oldXfIndex] = $newStyle->getIndex();
                                                }
                                        }
                                        
                                        // Loop through cells again and update the XF index
                                        for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {
                                                for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {
                                                        $cell = $this->getActiveSheet()->getCellByColumnAndRow($col, $row);
                                                        $oldXfIndex = $cell->getXfIndex();
                                                        $cell->setXfIndex($newXfIndexes[$oldXfIndex]);
                                                }
                                        }

                                } else {
                                        throw new Exception("Invalid style array passed.");
                                }
                                
                        } else {
                                if (array_key_exists('fill', $pStyles)) {
                                        $this->getFill()->applyFromArray($pStyles['fill']);
                                }
                                if (array_key_exists('font', $pStyles)) {
                                        $this->getFont()->applyFromArray($pStyles['font']);
                                }
                                if (array_key_exists('borders', $pStyles)) {
                                        $this->getBorders()->applyFromArray($pStyles['borders']);
                                }
                                if (array_key_exists('alignment', $pStyles)) {
                                        $this->getAlignment()->applyFromArray($pStyles['alignment']);
                                }
                                if (array_key_exists('numberformat', $pStyles)) {
                                        $this->getNumberFormat()->applyFromArray($pStyles['numberformat']);
                                }
                                if (array_key_exists('protection', $pStyles)) {
                                        $this->getProtection()->applyFromArray($pStyles['protection']);
                                }
                        }
                } else {
                        throw new Exception("Invalid style array passed.");
                }
                return $this;
        }

    public function getFill() {
                return $this->_fill;
    }
    
    public function getFont() {
                return $this->_font;
    }

        public function setFont(PHPExcel_Style_Font $font)
        {
                $this->_font = $font;
                return $this;
        }

    public function getBorders() {
                return $this->_borders;
    }
    
    public function getAlignment() {
                return $this->_alignment;
    }
    
    public function getNumberFormat() {
                return $this->_numberFormat;
    }
    
    public function getConditionalStyles() {
                return $this->getActiveSheet()->getConditionalStyles($this->getXActiveCell());
    }
       
    public function setConditionalStyles($pValue = null) {
                if (is_array($pValue)) {
                        foreach (PHPExcel_Cell::extractAllCellReferencesInRange($this->getXSelectedCells()) as $cellReference) {
                                $this->getActiveSheet()->setConditionalStyles($cellReference, $pValue);
                        }
                }
                return $this;
    }
    
    public function getProtection() {
                return $this->_protection;
    }
   
        public function getHashCode() {
                $hashConditionals = '';
                foreach ($this->_conditionalStyles as $conditional) {
                        $hashConditionals .= $conditional->getHashCode();
                }
                
        return md5(
                  $this->getFill()->getHashCode()
                . $this->getFont()->getHashCode()
                . $this->getBorders()->getHashCode()
                . $this->getAlignment()->getHashCode()
                . $this->getNumberFormat()->getHashCode()
                . $hashConditionals
                . $this->getProtection()->getHashCode()
                . __CLASS__
        );
    }
    
    private $_hashIndex;
    
        public function getHashIndex() {
                return $this->_hashIndex;
        }
        
        public function setHashIndex($value) {
                $this->_hashIndex = $value;
        }

        public function getIndex()
        {
                return $this->_index;
        }

        public function setIndex($pValue)
        {
                $this->_index = $pValue;
        }

        public function __clone() {
                $vars = get_object_vars($this);
                foreach ($vars as $key => $value) {
                        if (is_object($value)) {
                                $this->$key = clone $value;
                        } else {
                                $this->$key = $value;
                        }
                }
        }
}