public function PHPExcel_Worksheet_AutoFilter::testColumnInRange in Loft Data Grids 7.2

Same name and namespace in other branches

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

* Validate that the specified column is in the AutoFilter range * *

Parameters

string $column Column name (e.g. A): * @throws PHPExcel_Exception * @return integer The column offset within the autofilter range

4 calls to PHPExcel_Worksheet_AutoFilter::testColumnInRange()

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

* Clear a specified AutoFilter Column * *

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

* Get a specified AutoFilter Column * *

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

* Get a specified AutoFilter Column Offset within the defined AutoFilter range * *

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

* Set AutoFilter * *

File

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

Class

PHPExcel_Worksheet_AutoFilter

PHPExcel_Worksheet_AutoFilter

Code

public function testColumnInRange($column) {
  if (empty($this->_range)) {
    throw new PHPExcel_Exception("No autofilter range is defined.");
  }
  $columnIndex = PHPExcel_Cell::columnIndexFromString($column);
  list($rangeStart, $rangeEnd) = PHPExcel_Cell::rangeBoundaries($this->_range);
  if ($rangeStart[0] > $columnIndex || $rangeEnd[0] < $columnIndex) {
    throw new PHPExcel_Exception("Column is outside of current autofilter range.");
  }
  return $columnIndex - $rangeStart[0];
}