private function PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection()

* Write SheetProtection * *

Parameters

PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection()

PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php

* Write worksheet to XML format * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php, line 432

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

private function _writeSheetProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {

  // sheetProtection
  $objWriter
    ->startElement('sheetProtection');
  if ($pSheet
    ->getProtection()
    ->getPassword() != '') {
    $objWriter
      ->writeAttribute('password', $pSheet
      ->getProtection()
      ->getPassword());
  }
  $objWriter
    ->writeAttribute('sheet', $pSheet
    ->getProtection()
    ->getSheet() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('objects', $pSheet
    ->getProtection()
    ->getObjects() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('scenarios', $pSheet
    ->getProtection()
    ->getScenarios() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('formatCells', $pSheet
    ->getProtection()
    ->getFormatCells() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('formatColumns', $pSheet
    ->getProtection()
    ->getFormatColumns() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('formatRows', $pSheet
    ->getProtection()
    ->getFormatRows() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('insertColumns', $pSheet
    ->getProtection()
    ->getInsertColumns() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('insertRows', $pSheet
    ->getProtection()
    ->getInsertRows() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('insertHyperlinks', $pSheet
    ->getProtection()
    ->getInsertHyperlinks() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('deleteColumns', $pSheet
    ->getProtection()
    ->getDeleteColumns() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('deleteRows', $pSheet
    ->getProtection()
    ->getDeleteRows() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('selectLockedCells', $pSheet
    ->getProtection()
    ->getSelectLockedCells() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('sort', $pSheet
    ->getProtection()
    ->getSort() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('autoFilter', $pSheet
    ->getProtection()
    ->getAutoFilter() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('pivotTables', $pSheet
    ->getProtection()
    ->getPivotTables() ? 'true' : 'false');
  $objWriter
    ->writeAttribute('selectUnlockedCells', $pSheet
    ->getProtection()
    ->getSelectUnlockedCells() ? 'true' : 'false');
  $objWriter
    ->endElement();
}