private function PHPExcel_Worksheet_AutoFilter::_calculateTopTenValue in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php \PHPExcel_Worksheet_AutoFilter::_calculateTopTenValue()

1 call to PHPExcel_Worksheet_AutoFilter::_calculateTopTenValue()

PHPExcel_Worksheet_AutoFilter::showHideRows in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php

* Apply the AutoFilter rules to the AutoFilter Range * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php, line 580

Class

PHPExcel_Worksheet_AutoFilter

PHPExcel_Worksheet_AutoFilter

Code

private function _calculateTopTenValue($columnID, $startRow, $endRow, $ruleType, $ruleValue) {
  $range = $columnID . $startRow . ':' . $columnID . $endRow;
  $dataValues = PHPExcel_Calculation_Functions::flattenArray($this->_workSheet
    ->rangeToArray($range, NULL, TRUE, FALSE));
  $dataValues = array_filter($dataValues);
  if ($ruleType == PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_TOP) {
    rsort($dataValues);
  }
  else {
    sort($dataValues);
  }
  return array_pop(array_slice($dataValues, 0, $ruleValue));
}