NamedRange.php

Go to the documentation of this file.

<?php
class PHPExcel_NamedRange
{
        private $_name;

        private $_worksheet;

        private $_range;

        private $_localOnly;

        private $_scope;

    public function __construct($pName = null, PHPExcel_Worksheet $pWorksheet, $pRange = 'A1', $pLocalOnly = false, $pScope = null)
    {
        // Validate data
        if (is_null($pName) || is_null($pWorksheet)|| is_null($pRange)) {
                throw new Exception('Parameters can not be null.');
        }

        // Set local members
        $this->_name            = $pName;
        $this->_worksheet       = $pWorksheet;
        $this->_range           = $pRange;
        $this->_localOnly       = $pLocalOnly;
        $this->_scope           = ($pLocalOnly == true) ?
                                                                (($pScope == null) ? $pWorksheet : $pScope) : null;
    }

    public function getName() {
        return $this->_name;
    }

    public function setName($value = null) {
        if (!is_null($value)) {
                // Old title
                $oldTitle = $this->_name;

                // Re-attach
                if (!is_null($this->_worksheet)) {
                        $this->_worksheet->getParent()->removeNamedRange($this->_name,$this->_worksheet);
                }
                $this->_name = $value;

                if (!is_null($this->_worksheet)) {
                        $this->_worksheet->getParent()->addNamedRange($this);
                }

                // New title
                $newTitle = $this->_name;
                PHPExcel_ReferenceHelper::getInstance()->updateNamedFormulas($this->_worksheet->getParent(), $oldTitle, $newTitle);
        }
        return $this;
    }

    public function getWorksheet() {
        return $this->_worksheet;
    }

    public function setWorksheet(PHPExcel_Worksheet $value = null) {
        if (!is_null($value)) {
                $this->_worksheet = $value;
        }
        return $this;
    }

    public function getRange() {
        return $this->_range;
    }

    public function setRange($value = null) {
        if (!is_null($value)) {
                $this->_range = $value;
        }
        return $this;
    }

    public function getLocalOnly() {
        return $this->_localOnly;
    }

    public function setLocalOnly($value = false) {
        $this->_localOnly = $value;
        $this->_scope = $value ? $this->_worksheet : null;
        return $this;
    }

    public function getScope() {
        return $this->_scope;
    }

    public function setScope(PHPExcel_Worksheet $value = null) {
        $this->_scope = $value;
        $this->_localOnly = ($value == null) ? false : true;
        return $this;
    }

    public static function resolveRange($pNamedRange = '', PHPExcel_Worksheet $pSheet) {
                return $pSheet->getParent()->getNamedRange($pNamedRange, $pSheet);
    }

        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;
                        }
                }
        }
}