You are here

class PHPExcel_Worksheet_Protection in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/Protection.php \PHPExcel_Worksheet_Protection

PHPExcel_Worksheet_Protection

@category PHPExcel @package PHPExcel_Worksheet @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Worksheet_Protection

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/Protection.php, line 36

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

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Worksheet_Protection::$_autoFilter private property * AutoFilter * *
PHPExcel_Worksheet_Protection::$_deleteColumns private property * Delete columns * *
PHPExcel_Worksheet_Protection::$_deleteRows private property * Delete rows * *
PHPExcel_Worksheet_Protection::$_formatCells private property * Format cells * *
PHPExcel_Worksheet_Protection::$_formatColumns private property * Format columns * *
PHPExcel_Worksheet_Protection::$_formatRows private property * Format rows * *
PHPExcel_Worksheet_Protection::$_insertColumns private property * Insert columns * *
PHPExcel_Worksheet_Protection::$_insertHyperlinks private property * Insert hyperlinks * *
PHPExcel_Worksheet_Protection::$_insertRows private property * Insert rows * *
PHPExcel_Worksheet_Protection::$_objects private property * Objects * *
PHPExcel_Worksheet_Protection::$_password private property * Password * *
PHPExcel_Worksheet_Protection::$_pivotTables private property * Pivot tables * *
PHPExcel_Worksheet_Protection::$_scenarios private property * Scenarios * *
PHPExcel_Worksheet_Protection::$_selectLockedCells private property * Select locked cells * *
PHPExcel_Worksheet_Protection::$_selectUnlockedCells private property * Select unlocked cells * *
PHPExcel_Worksheet_Protection::$_sheet private property * Sheet * *
PHPExcel_Worksheet_Protection::$_sort private property * Sort * *
PHPExcel_Worksheet_Protection::getAutoFilter function Get AutoFilter
PHPExcel_Worksheet_Protection::getDeleteColumns function Get DeleteColumns
PHPExcel_Worksheet_Protection::getDeleteRows function Get DeleteRows
PHPExcel_Worksheet_Protection::getFormatCells function Get FormatCells
PHPExcel_Worksheet_Protection::getFormatColumns function Get FormatColumns
PHPExcel_Worksheet_Protection::getFormatRows function Get FormatRows
PHPExcel_Worksheet_Protection::getInsertColumns function Get InsertColumns
PHPExcel_Worksheet_Protection::getInsertHyperlinks function Get InsertHyperlinks
PHPExcel_Worksheet_Protection::getInsertRows function Get InsertRows
PHPExcel_Worksheet_Protection::getObjects function Get Objects
PHPExcel_Worksheet_Protection::getPassword function Get Password (hashed)
PHPExcel_Worksheet_Protection::getPivotTables function Get PivotTables
PHPExcel_Worksheet_Protection::getScenarios function Get Scenarios
PHPExcel_Worksheet_Protection::getSelectLockedCells function Get SelectLockedCells
PHPExcel_Worksheet_Protection::getSelectUnlockedCells function Get SelectUnlockedCells
PHPExcel_Worksheet_Protection::getSheet function Get Sheet
PHPExcel_Worksheet_Protection::getSort function Get Sort
PHPExcel_Worksheet_Protection::isProtectionEnabled function Is some sort of protection enabled?
PHPExcel_Worksheet_Protection::setAutoFilter function Set AutoFilter
PHPExcel_Worksheet_Protection::setDeleteColumns function Set DeleteColumns
PHPExcel_Worksheet_Protection::setDeleteRows function Set DeleteRows
PHPExcel_Worksheet_Protection::setFormatCells function Set FormatCells
PHPExcel_Worksheet_Protection::setFormatColumns function Set FormatColumns
PHPExcel_Worksheet_Protection::setFormatRows function Set FormatRows
PHPExcel_Worksheet_Protection::setInsertColumns function Set InsertColumns
PHPExcel_Worksheet_Protection::setInsertHyperlinks function Set InsertHyperlinks
PHPExcel_Worksheet_Protection::setInsertRows function Set InsertRows
PHPExcel_Worksheet_Protection::setObjects function Set Objects
PHPExcel_Worksheet_Protection::setPassword function Set Password
PHPExcel_Worksheet_Protection::setPivotTables function Set PivotTables
PHPExcel_Worksheet_Protection::setScenarios function Set Scenarios
PHPExcel_Worksheet_Protection::setSelectLockedCells function Set SelectLockedCells
PHPExcel_Worksheet_Protection::setSelectUnlockedCells function Set SelectUnlockedCells
PHPExcel_Worksheet_Protection::setSheet function Set Sheet
PHPExcel_Worksheet_Protection::setSort function Set Sort
PHPExcel_Worksheet_Protection::__clone public function * Implement PHP __clone to create a deep clone, not just a shallow copy.
PHPExcel_Worksheet_Protection::__construct public function Create a new PHPExcel_Worksheet_Protection