?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/prestashop17/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xlsx/

?? Go up: /home/webdevt/prestashop17/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader

?? Editing: DataValidations.php

<?php

namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx;

use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class DataValidations
{
    private $worksheet;

private $worksheetXml;

public function __construct(Worksheet $workSheet, \SimpleXMLElement $worksheetXml)
    {
        $this->worksheet = $workSheet;
        $this->worksheetXml = $worksheetXml;
    }

public function load()
    {
        foreach ($this->worksheetXml->dataValidations->dataValidation as $dataValidation) {
            // Uppercase coordinate
            $range = strtoupper($dataValidation['sqref']);
            $rangeSet = explode(' ', $range);
            foreach ($rangeSet as $range) {
                $stRange = $this->worksheet->shrinkRangeToFit($range);

// Extract all cell references in $range
                foreach (Coordinate::extractAllCellReferencesInRange($stRange) as $reference) {
                    // Create validation
                    $docValidation = $this->worksheet->getCell($reference)->getDataValidation();
                    $docValidation->setType((string) $dataValidation['type']);
                    $docValidation->setErrorStyle((string) $dataValidation['errorStyle']);
                    $docValidation->setOperator((string) $dataValidation['operator']);
                    $docValidation->setAllowBlank($dataValidation['allowBlank'] != 0);
                    $docValidation->setShowDropDown($dataValidation['showDropDown'] == 0);
                    $docValidation->setShowInputMessage($dataValidation['showInputMessage'] != 0);
                    $docValidation->setShowErrorMessage($dataValidation['showErrorMessage'] != 0);
                    $docValidation->setErrorTitle((string) $dataValidation['errorTitle']);
                    $docValidation->setError((string) $dataValidation['error']);
                    $docValidation->setPromptTitle((string) $dataValidation['promptTitle']);
                    $docValidation->setPrompt((string) $dataValidation['prompt']);
                    $docValidation->setFormula1((string) $dataValidation->formula1);
                    $docValidation->setFormula2((string) $dataValidation->formula2);
                }
            }
        }
    }
}

?? AutoFilter.php | ?? Edit | ??? Delete
?? BaseParserClass.php | ?? Edit | ??? Delete
?? Chart.php | ?? Edit | ??? Delete
?? ColumnAndRowAttributes.php | ?? Edit | ??? Delete
?? ConditionalStyles.php | ?? Edit | ??? Delete
?? DataValidations.php | ?? Edit | ??? Delete
?? Hyperlinks.php | ?? Edit | ??? Delete
?? PageSetup.php | ?? Edit | ??? Delete
?? Properties.php | ?? Edit | ??? Delete
?? SheetViewOptions.php | ?? Edit | ??? Delete
?? SheetViews.php | ?? Edit | ??? Delete
?? Styles.php | ?? Edit | ??? Delete
?? Theme.php | ?? Edit | ??? Delete