From f1ab2f022fdc780aca0944d90e9a0e844a0820d7 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Anton=20Luka=20=C5=A0ijanec?= Date: Mon, 27 May 2024 13:12:17 +0200 Subject: =?UTF-8?q?2024-02-19:=20popravljen=20(prej=C5=A1nji=20commit=20je?= =?UTF-8?q?=20napa=C4=8Den)?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- admin/survey/excel/PHPExcel/NamedRange.php | 245 ----------------------------- 1 file changed, 245 deletions(-) delete mode 100644 admin/survey/excel/PHPExcel/NamedRange.php (limited to 'admin/survey/excel/PHPExcel/NamedRange.php') diff --git a/admin/survey/excel/PHPExcel/NamedRange.php b/admin/survey/excel/PHPExcel/NamedRange.php deleted file mode 100644 index 05b6835..0000000 --- a/admin/survey/excel/PHPExcel/NamedRange.php +++ /dev/null @@ -1,245 +0,0 @@ -_worksheet) - * - * @var bool - */ - private $_localOnly; - - /** - * Scope - * - * @var PHPExcel_Worksheet - */ - private $_scope; - - /** - * Create a new NamedRange - * - * @param string $pName - * @param PHPExcel_Worksheet $pWorksheet - * @param string $pRange - * @param bool $pLocalOnly - * @param PHPExcel_Worksheet|null $pScope Scope. Only applies when $pLocalOnly = true. Null for global scope. - */ - public function __construct($pName = null, PHPExcel_Worksheet $pWorksheet, $pRange = 'A1', $pLocalOnly = false, $pScope = null) - { - // Validate data - if (($pName === NULL) || ($pWorksheet === NULL) || ($pRange === NULL)) { - 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; - } - - /** - * Get name - * - * @return string - */ - public function getName() { - return $this->_name; - } - - /** - * Set name - * - * @param string $value - * @return PHPExcel_NamedRange - */ - public function setName($value = null) { - if ($value !== NULL) { - // Old title - $oldTitle = $this->_name; - - // Re-attach - if ($this->_worksheet !== NULL) { - $this->_worksheet->getParent()->removeNamedRange($this->_name,$this->_worksheet); - } - $this->_name = $value; - - if ($this->_worksheet !== NULL) { - $this->_worksheet->getParent()->addNamedRange($this); - } - - // New title - $newTitle = $this->_name; - PHPExcel_ReferenceHelper::getInstance()->updateNamedFormulas($this->_worksheet->getParent(), $oldTitle, $newTitle); - } - return $this; - } - - /** - * Get worksheet - * - * @return PHPExcel_Worksheet - */ - public function getWorksheet() { - return $this->_worksheet; - } - - /** - * Set worksheet - * - * @param PHPExcel_Worksheet $value - * @return PHPExcel_NamedRange - */ - public function setWorksheet(PHPExcel_Worksheet $value = null) { - if ($value !== NULL) { - $this->_worksheet = $value; - } - return $this; - } - - /** - * Get range - * - * @return string - */ - public function getRange() { - return $this->_range; - } - - /** - * Set range - * - * @param string $value - * @return PHPExcel_NamedRange - */ - public function setRange($value = null) { - if ($value !== NULL) { - $this->_range = $value; - } - return $this; - } - - /** - * Get localOnly - * - * @return bool - */ - public function getLocalOnly() { - return $this->_localOnly; - } - - /** - * Set localOnly - * - * @param bool $value - * @return PHPExcel_NamedRange - */ - public function setLocalOnly($value = false) { - $this->_localOnly = $value; - $this->_scope = $value ? $this->_worksheet : null; - return $this; - } - - /** - * Get scope - * - * @return PHPExcel_Worksheet|null - */ - public function getScope() { - return $this->_scope; - } - - /** - * Set scope - * - * @param PHPExcel_Worksheet|null $value - * @return PHPExcel_NamedRange - */ - public function setScope(PHPExcel_Worksheet $value = null) { - $this->_scope = $value; - $this->_localOnly = ($value == null) ? false : true; - return $this; - } - - /** - * Resolve a named range to a regular cell range - * - * @param string $pNamedRange Named range - * @param PHPExcel_Worksheet|null $pSheet Scope. Use null for global scope - * @return PHPExcel_NamedRange - */ - public static function resolveRange($pNamedRange = '', PHPExcel_Worksheet $pSheet) { - return $pSheet->getParent()->getNamedRange($pNamedRange, $pSheet); - } - - /** - * Implement PHP __clone to create a deep clone, not just a shallow copy. - */ - 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; - } - } - } -} -- cgit v1.2.3