Devolve o parâmetro correto de alinhamento vertical, com base
nas constantes da biblioteca PHPSpreadsheet

@return string
423543
private function getMappedVerticalAlign($param)
    {
        switch($param) {
            case 'top':
                $align = \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP;
                break;
            case 'middle':
                $align = \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER;
                break;
            case 'bottom':
                $align = \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_BOTTOM;
                break;
            default:
                $align = \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER;
        }

        return $align;
    }
588486
public static function STDEVP()
    {
        $aArgs = PHPExcel_Calculation_Functions::flattenArrayIndexed(func_get_args());

        $returnValue = null;

        $aMean = self::AVERAGE($aArgs);
        if (!is_null($aMean)) {
            $aCount = 0;
            foreach ($aArgs as $k => $arg) {
                if ((is_bool($arg)) &&
                    ((!PHPExcel_Calculation_Functions::isCellValue($k)) || (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE))) {
                    $arg = (integer) $arg;
                }
                // Is it a numeric value?
                if ((is_numeric($arg)) && (!is_string($arg))) {
                    if (is_null($returnValue)) {
                        $returnValue = pow(($arg - $aMean), 2);
                    } else {
                        $returnValue += pow(($arg - $aMean), 2);
                    }
                    ++$aCount;
                }
            }

            if (($aCount > 0) && ($returnValue >= 0)) {
                return sqrt($returnValue / $aCount);
            }
        }
        return PHPExcel_Calculation_Functions::DIV0();
    }
46882
public function getParameters()
    {
        $lastIndent = null;
        $parameters = array();

        if ($parameterComment = $this->getParametersComment()) {
            $parameterLines = explode("\n", $parameterComment);
            foreach ($parameterLines as $line) {
                if (empty($line)) {
                    continue;
                }

                $lineParts = explode(' - ', $line);

                $name = trim(array_shift($lineParts));

                $description = '';
                if (!empty($lineParts)) {
                    $description = trim(implode(' - ', $lineParts));
                }
                $parameter = new Parameter($name, $description);

                $parameters[] = $parameter;
            }
        }

        return $parameters;
    }
81951
public function columns()
    {
        return $this->scaffoldColumns()
                    ->without(['slug'])
                    ->update('title', function (Element $title) {
                        return $title->setStandalone(true);
                    })
                    ->push((new Element('url'))->setTemplate(function ($row) {
                        return link_to($row->url, $row->title, ['target' => '_blank']);
                    }))
                    ->join(['title', 'url'], 'info', 1);
    }
513601
public function getAddUrlParams()
    {
        $sAddParams = parent::getAddUrlParams();
        $sAddParams .= ($sAddParams ? '&amp;' : '') . "listtype={$this->_sListType}";

        if ($oRecommList = $this->getActiveRecommList()) {
            $sAddParams .= "&amp;recommid=" . $oRecommList->getId();
        }

        return $sAddParams;
    }
552056
protected function getWrapperArgs(): string
  {
    $ret = '';

    if ($this->routine['designation']=='bulk')
    {
      $ret .= 'BulkHandler $bulkHandler';
    }

    foreach ($this->routine['parameters'] as $i => $parameter)
    {
      if ($ret!='') $ret .= ', ';

      $dataType    = DataTypeHelper::columnTypeToPhpTypeHinting($parameter);
      $declaration = DataTypeHelper::phpTypeHintingToPhpTypeDeclaration($dataType.'|null');
      if ($declaration!=='')
      {
        $ret .= $declaration.' ';
      }

      $ret .= '$'.$this->nameMangler->getParameterName($parameter['parameter_name']);
    }

    return $ret;
  }
1261827
private function readClientAnchor()
    {
        $length = PHPExcel_Reader_Excel5::getInt4d($this->data, $this->pos + 4);
        $recordData = substr($this->data, $this->pos + 8, $length);

        // move stream pointer to next record
        $this->pos += 8 + $length;

        // offset: 2; size: 2; upper-left corner column index (0-based)
        $c1 = PHPExcel_Reader_Excel5::getInt2d($recordData, 2);

        // offset: 4; size: 2; upper-left corner horizontal offset in 1/1024 of column width
        $startOffsetX = PHPExcel_Reader_Excel5::getInt2d($recordData, 4);

        // offset: 6; size: 2; upper-left corner row index (0-based)
        $r1 = PHPExcel_Reader_Excel5::getInt2d($recordData, 6);

        // offset: 8; size: 2; upper-left corner vertical offset in 1/256 of row height
        $startOffsetY = PHPExcel_Reader_Excel5::getInt2d($recordData, 8);

        // offset: 10; size: 2; bottom-right corner column index (0-based)
        $c2 = PHPExcel_Reader_Excel5::getInt2d($recordData, 10);

        // offset: 12; size: 2; bottom-right corner horizontal offset in 1/1024 of column width
        $endOffsetX = PHPExcel_Reader_Excel5::getInt2d($recordData, 12);

        // offset: 14; size: 2; bottom-right corner row index (0-based)
        $r2 = PHPExcel_Reader_Excel5::getInt2d($recordData, 14);

        // offset: 16; size: 2; bottom-right corner vertical offset in 1/256 of row height
        $endOffsetY = PHPExcel_Reader_Excel5::getInt2d($recordData, 16);

        // set the start coordinates
        $this->object->setStartCoordinates(PHPExcel_Cell::stringFromColumnIndex($c1) . ($r1 + 1));

        // set the start offsetX
        $this->object->setStartOffsetX($startOffsetX);

        // set the start offsetY
        $this->object->setStartOffsetY($startOffsetY);

        // set the end coordinates
        $this->object->setEndCoordinates(PHPExcel_Cell::stringFromColumnIndex($c2) . ($r2 + 1));

        // set the end offsetX
        $this->object->setEndOffsetX($endOffsetX);

        // set the end offsetY
        $this->object->setEndOffsetY($endOffsetY);
    }
1172021
private function getTableHf()
    {
        if ($this->HFContent) return $this->HFContent;

        ob_start();
        ?>
        <tr>
            <?php // Start constructing the table header columns ?>
            <?php foreach ($this->columns as $column_key => $column_options) : ?>

                <?php $sortable_class = $this->getSortableClass($column_key); ?>

                <th data-column-name="<?php echo $column_key; ?>"
                    class="<?php echo $sortable_class; ?> <?php echo $this->getColumnOption($column_key, self::COLUMN_OPTION_CLASSES); ?>"
                    <?php echo $this->getColumnOption($column_key, self::COLUMN_OPTION_THEAD_ATTR) ?>>

                    <?php echo $this->getColumnHeaderStructure($column_key, $column_options); ?>
                </th>
            <?php endforeach; ?>
        </tr>

        <?php

        $this->HFContent = ob_get_clean();

        return $this->HFContent;
    }
460987
public function getConstantSuffix()
    {
        $separator = PhpNameGenerator::STD_SEPARATOR_CHAR;
        return strtoupper(rtrim(preg_replace('/(\W|_)+/', $separator, $this->key), $separator));
    }
271673
public function getBrowseColumns()
    {
        // Newline placeholder
        $br = \MUtil_Html::create('br');
        $sp = \MUtil_Html::raw(' ');

        $columns[10] = array('glo_name', $br, 'glo_organizations');
        $columns[20] = array('glo_url', $br, 'glo_url_route');
        $columns[30] = array('glo_address_1', $br, 'glo_zipcode', \MUtil_Html::raw('&nbsp;&nbsp;'), 'glo_city');
        $columns[40] = array(\MUtil_Html::raw('&#9743; '), 'glo_phone_1', $br, 'glo_filter', $sp, 'glo_match_to');

        return $columns;
    }
451061
public function toRequestParams()
    {
        $ret = array(
            "name" => $this->_name,
            "description" => $this->_description
        );

        foreach ($this->_fields as $column => $fields)
        {
            foreach ($fields as $field)
            {
                if ($field instanceof ObjectField)
                {
                    $ret["fields"][$column][] = $field->toRequestParams();
                }
            }
        }
        // Convert from an assoc array to a numeric array.
        // This will move items from the 3rd column to the 2nd if the 2nd isn't populated.
        $ret["fields"] = array_values($ret["fields"]);
        return $ret;
    }
1016898
public static function getRangeAll()
    {
        $sheetObj = self::validSheetObj();
        
        return self::num2alpha(self::$_offsetCol+1). '1:'. $sheetObj->getHighestColumn(). $sheetObj->getHighestRow();
    }
481577
public function getParam(): string
    {
        if ($this->options->is_null('param')) {
            $this->options->set('param', 'page' . (1 == self::$iPagination ? '' : self::$iPagination));
        }

        return $this->options->get('param');
    }
17230
public function columnsDoc()
    {
        $ret = str_pad('Name', 25, ' ') . '|' . str_pad('Type', 15, ' ') . '|Info' . "\n";
        $ret .= str_repeat('-', 25) . '|' . str_repeat('-', 15) . '|' . str_repeat('-', 10) . "\n";
        foreach ($this->columns as $name => $info) {
            $ret .= str_pad($name, 25, ' ') . '|';
            $ret .= str_pad($info['type'], 15, ' ') . '|';
            if (isset($info['primary_key'])) {
                $ret .= 'PK ';
            }
            if (isset($info['index'])) {
                $ret .= 'Indexed ';
            }
            if (isset($info['increment'])) {
                $ret .= 'Increment ';
            }
            if (isset($info['default'])) {
                $ret .= 'Default=' . $info['default'];
            }
            $ret .= "\n";
        }

        return $ret;
    }
1282673
public function getDefaultPathParams()
    {
        // default values
        $aParams['sShopDir'] = "";
        $aParams['sShopURL'] = "";

        // try path translated
        if (isset($_SERVER['PATH_TRANSLATED']) && ($_SERVER['PATH_TRANSLATED'] != '')) {
            $sFilepath = $_SERVER['PATH_TRANSLATED'];
        } else {
            $sFilepath = $_SERVER['SCRIPT_FILENAME'];
        }

        $aParams['sShopDir'] = str_replace("\\", "/", $this->_extractPath(preg_split("/\\\|\//", $sFilepath)));
        $aParams['sCompileDir'] = $aParams['sShopDir'] . "tmp/";

        // try referer
        $sFilepath = @$_SERVER['HTTP_REFERER'];
        if (!isset($sFilepath) || !$sFilepath) {
            $sFilepath = "http://" . @$_SERVER['HTTP_HOST'] . @$_SERVER['SCRIPT_NAME'];
        }
        $aParams['sShopURL'] = ltrim($this->_extractPath(explode("/", $sFilepath)), "/");

        return $aParams;
    }
1341260
public function getGeneralParam()
    {
        $params = array();
        $params[] = array(
            'name' => 'title',
            'type' => 'String',
            'unit' => 'none',
            'title' => 'title',
            'description' => 'beackend title',
            'editable' => true,
            'visible' => true,
            'priority' => 5,
            'symbol' => 'title',
            'defaultValue' => 'no title',
            'validators' => [
                'NotNull',
                'NotEmpty'
            ]
        );
        $params[] = array(
            'name' => 'description',
            'type' => 'String',
            'unit' => 'none',
            'title' => 'description',
            'description' => 'beackend description',
            'editable' => true,
            'visible' => true,
            'priority' => 5,
            'symbol' => 'title',
            'defaultValue' => 'description',
            'validators' => []
        );
        $params[] = array(
            'name' => 'symbol',
            'type' => 'String',
            'unit' => 'none',
            'title' => 'Symbol',
            'description' => 'beackend symbol',
            'editable' => true,
            'visible' => true,
            'priority' => 5,
            'symbol' => 'icon',
            'defaultValue' => '',
            'validators' => []
        );
        return $params;
    }
578292
protected function getSlugRouteParameters()
    {
        $slugPath = '/{url}';
        $slugDefaults = array(
            '_controller' => 'KunstmaanNodeBundle:Slug:slug',
            'preview' => false,
            'url' => '',
            '_locale' => $this->getDefaultLocale(),
        );
        $slugRequirements = array(
            'url' => $this->getSlugPattern(),
        );

        if ($this->isMultiLanguage()) {
            $slugPath = '/{_locale}' . $slugPath;
            unset($slugDefaults['_locale']);
            $slugRequirements['_locale'] = $this->getEscapedLocales($this->getFrontendLocales());
        }

        return array(
            'path' => $slugPath,
            'defaults' => $slugDefaults,
            'requirements' => $slugRequirements,
        );
    }