public function PHPExcel_Worksheet::unprotectCells in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::unprotectCells()

Remove protection on a cell range

Parameters

string $pRange Cell (e.g. A1) or cell range (e.g. A1:E1):

Return value

PHPExcel_Worksheet

Throws

PHPExcel_Exception

1 call to PHPExcel_Worksheet::unprotectCells()

PHPExcel_Worksheet::unprotectCellsByColumnAndRow in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php

Remove protection on a cell range by using numeric cell coordinates

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php, line 1846

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function unprotectCells($pRange = 'A1') {

  // Uppercase coordinate
  $pRange = strtoupper($pRange);
  if (isset($this->_protectedCells[$pRange])) {
    unset($this->_protectedCells[$pRange]);
  }
  else {
    throw new PHPExcel_Exception('Cell range ' . $pRange . ' not known as protected.');
  }
  return $this;
}