123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545 |
- <?php
- /**
- * PHPExcel
- *
- * Copyright (c) 2006 - 2014 PHPExcel
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Lesser General Public
- * License as published by the Free Software Foundation; either
- * version 2.1 of the License, or (at your option) any later version.
- *
- * This library is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this library; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
- *
- * @category PHPExcel
- * @package PHPExcel_Worksheet
- * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
- * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
- * @version ##VERSION##, ##DATE##
- */
- /**
- * PHPExcel_Worksheet_Protection
- *
- * @category PHPExcel
- * @package PHPExcel_Worksheet
- * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
- */
- class PHPExcel_Worksheet_Protection
- {
- /**
- * Sheet
- *
- * @var boolean
- */
- private $_sheet = false;
- /**
- * Objects
- *
- * @var boolean
- */
- private $_objects = false;
- /**
- * Scenarios
- *
- * @var boolean
- */
- private $_scenarios = false;
- /**
- * Format cells
- *
- * @var boolean
- */
- private $_formatCells = false;
- /**
- * Format columns
- *
- * @var boolean
- */
- private $_formatColumns = false;
- /**
- * Format rows
- *
- * @var boolean
- */
- private $_formatRows = false;
- /**
- * Insert columns
- *
- * @var boolean
- */
- private $_insertColumns = false;
- /**
- * Insert rows
- *
- * @var boolean
- */
- private $_insertRows = false;
- /**
- * Insert hyperlinks
- *
- * @var boolean
- */
- private $_insertHyperlinks = false;
- /**
- * Delete columns
- *
- * @var boolean
- */
- private $_deleteColumns = false;
- /**
- * Delete rows
- *
- * @var boolean
- */
- private $_deleteRows = false;
- /**
- * Select locked cells
- *
- * @var boolean
- */
- private $_selectLockedCells = false;
- /**
- * Sort
- *
- * @var boolean
- */
- private $_sort = false;
- /**
- * AutoFilter
- *
- * @var boolean
- */
- private $_autoFilter = false;
- /**
- * Pivot tables
- *
- * @var boolean
- */
- private $_pivotTables = false;
- /**
- * Select unlocked cells
- *
- * @var boolean
- */
- private $_selectUnlockedCells = false;
- /**
- * Password
- *
- * @var string
- */
- private $_password = '';
- /**
- * Create a new PHPExcel_Worksheet_Protection
- */
- public function __construct()
- {
- }
- /**
- * Is some sort of protection enabled?
- *
- * @return boolean
- */
- function isProtectionEnabled() {
- return $this->_sheet ||
- $this->_objects ||
- $this->_scenarios ||
- $this->_formatCells ||
- $this->_formatColumns ||
- $this->_formatRows ||
- $this->_insertColumns ||
- $this->_insertRows ||
- $this->_insertHyperlinks ||
- $this->_deleteColumns ||
- $this->_deleteRows ||
- $this->_selectLockedCells ||
- $this->_sort ||
- $this->_autoFilter ||
- $this->_pivotTables ||
- $this->_selectUnlockedCells;
- }
- /**
- * Get Sheet
- *
- * @return boolean
- */
- function getSheet() {
- return $this->_sheet;
- }
- /**
- * Set Sheet
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setSheet($pValue = false) {
- $this->_sheet = $pValue;
- return $this;
- }
- /**
- * Get Objects
- *
- * @return boolean
- */
- function getObjects() {
- return $this->_objects;
- }
- /**
- * Set Objects
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setObjects($pValue = false) {
- $this->_objects = $pValue;
- return $this;
- }
- /**
- * Get Scenarios
- *
- * @return boolean
- */
- function getScenarios() {
- return $this->_scenarios;
- }
- /**
- * Set Scenarios
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setScenarios($pValue = false) {
- $this->_scenarios = $pValue;
- return $this;
- }
- /**
- * Get FormatCells
- *
- * @return boolean
- */
- function getFormatCells() {
- return $this->_formatCells;
- }
- /**
- * Set FormatCells
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setFormatCells($pValue = false) {
- $this->_formatCells = $pValue;
- return $this;
- }
- /**
- * Get FormatColumns
- *
- * @return boolean
- */
- function getFormatColumns() {
- return $this->_formatColumns;
- }
- /**
- * Set FormatColumns
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setFormatColumns($pValue = false) {
- $this->_formatColumns = $pValue;
- return $this;
- }
- /**
- * Get FormatRows
- *
- * @return boolean
- */
- function getFormatRows() {
- return $this->_formatRows;
- }
- /**
- * Set FormatRows
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setFormatRows($pValue = false) {
- $this->_formatRows = $pValue;
- return $this;
- }
- /**
- * Get InsertColumns
- *
- * @return boolean
- */
- function getInsertColumns() {
- return $this->_insertColumns;
- }
- /**
- * Set InsertColumns
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setInsertColumns($pValue = false) {
- $this->_insertColumns = $pValue;
- return $this;
- }
- /**
- * Get InsertRows
- *
- * @return boolean
- */
- function getInsertRows() {
- return $this->_insertRows;
- }
- /**
- * Set InsertRows
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setInsertRows($pValue = false) {
- $this->_insertRows = $pValue;
- return $this;
- }
- /**
- * Get InsertHyperlinks
- *
- * @return boolean
- */
- function getInsertHyperlinks() {
- return $this->_insertHyperlinks;
- }
- /**
- * Set InsertHyperlinks
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setInsertHyperlinks($pValue = false) {
- $this->_insertHyperlinks = $pValue;
- return $this;
- }
- /**
- * Get DeleteColumns
- *
- * @return boolean
- */
- function getDeleteColumns() {
- return $this->_deleteColumns;
- }
- /**
- * Set DeleteColumns
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setDeleteColumns($pValue = false) {
- $this->_deleteColumns = $pValue;
- return $this;
- }
- /**
- * Get DeleteRows
- *
- * @return boolean
- */
- function getDeleteRows() {
- return $this->_deleteRows;
- }
- /**
- * Set DeleteRows
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setDeleteRows($pValue = false) {
- $this->_deleteRows = $pValue;
- return $this;
- }
- /**
- * Get SelectLockedCells
- *
- * @return boolean
- */
- function getSelectLockedCells() {
- return $this->_selectLockedCells;
- }
- /**
- * Set SelectLockedCells
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setSelectLockedCells($pValue = false) {
- $this->_selectLockedCells = $pValue;
- return $this;
- }
- /**
- * Get Sort
- *
- * @return boolean
- */
- function getSort() {
- return $this->_sort;
- }
- /**
- * Set Sort
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setSort($pValue = false) {
- $this->_sort = $pValue;
- return $this;
- }
- /**
- * Get AutoFilter
- *
- * @return boolean
- */
- function getAutoFilter() {
- return $this->_autoFilter;
- }
- /**
- * Set AutoFilter
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setAutoFilter($pValue = false) {
- $this->_autoFilter = $pValue;
- return $this;
- }
- /**
- * Get PivotTables
- *
- * @return boolean
- */
- function getPivotTables() {
- return $this->_pivotTables;
- }
- /**
- * Set PivotTables
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setPivotTables($pValue = false) {
- $this->_pivotTables = $pValue;
- return $this;
- }
- /**
- * Get SelectUnlockedCells
- *
- * @return boolean
- */
- function getSelectUnlockedCells() {
- return $this->_selectUnlockedCells;
- }
- /**
- * Set SelectUnlockedCells
- *
- * @param boolean $pValue
- * @return PHPExcel_Worksheet_Protection
- */
- function setSelectUnlockedCells($pValue = false) {
- $this->_selectUnlockedCells = $pValue;
- return $this;
- }
- /**
- * Get Password (hashed)
- *
- * @return string
- */
- function getPassword() {
- return $this->_password;
- }
- /**
- * Set Password
- *
- * @param string $pValue
- * @param boolean $pAlreadyHashed If the password has already been hashed, set this to true
- * @return PHPExcel_Worksheet_Protection
- */
- function setPassword($pValue = '', $pAlreadyHashed = false) {
- if (!$pAlreadyHashed) {
- $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue);
- }
- $this->_password = $pValue;
- return $this;
- }
- /**
- * 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;
- }
- }
- }
- }
|