private function PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations in Loft Data Grids 7.2

Same name and namespace in other branches

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

* Write DataValidations * *

Parameters

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

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeDataValidations()

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 542

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

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

  // Datavalidation collection
  $dataValidationCollection = $pSheet
    ->getDataValidationCollection();

  // Write data validations?
  if (!empty($dataValidationCollection)) {
    $objWriter
      ->startElement('dataValidations');
    $objWriter
      ->writeAttribute('count', count($dataValidationCollection));
    foreach ($dataValidationCollection as $coordinate => $dv) {
      $objWriter
        ->startElement('dataValidation');
      if ($dv
        ->getType() != '') {
        $objWriter
          ->writeAttribute('type', $dv
          ->getType());
      }
      if ($dv
        ->getErrorStyle() != '') {
        $objWriter
          ->writeAttribute('errorStyle', $dv
          ->getErrorStyle());
      }
      if ($dv
        ->getOperator() != '') {
        $objWriter
          ->writeAttribute('operator', $dv
          ->getOperator());
      }
      $objWriter
        ->writeAttribute('allowBlank', $dv
        ->getAllowBlank() ? '1' : '0');
      $objWriter
        ->writeAttribute('showDropDown', !$dv
        ->getShowDropDown() ? '1' : '0');
      $objWriter
        ->writeAttribute('showInputMessage', $dv
        ->getShowInputMessage() ? '1' : '0');
      $objWriter
        ->writeAttribute('showErrorMessage', $dv
        ->getShowErrorMessage() ? '1' : '0');
      if ($dv
        ->getErrorTitle() !== '') {
        $objWriter
          ->writeAttribute('errorTitle', $dv
          ->getErrorTitle());
      }
      if ($dv
        ->getError() !== '') {
        $objWriter
          ->writeAttribute('error', $dv
          ->getError());
      }
      if ($dv
        ->getPromptTitle() !== '') {
        $objWriter
          ->writeAttribute('promptTitle', $dv
          ->getPromptTitle());
      }
      if ($dv
        ->getPrompt() !== '') {
        $objWriter
          ->writeAttribute('prompt', $dv
          ->getPrompt());
      }
      $objWriter
        ->writeAttribute('sqref', $coordinate);
      if ($dv
        ->getFormula1() !== '') {
        $objWriter
          ->writeElement('formula1', $dv
          ->getFormula1());
      }
      if ($dv
        ->getFormula2() !== '') {
        $objWriter
          ->writeElement('formula2', $dv
          ->getFormula2());
      }
      $objWriter
        ->endElement();
    }
    $objWriter
      ->endElement();
  }
}