Class PHPExcel_Worksheet_AutoFilter
PHPExcel_Worksheet_AutoFilter
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Worksheet/AutoFilter.php
public
|
#
__construct( string $pRange = '',
Create a new PHPExcel_Worksheet_AutoFilter |
public
|
|
public
|
|
public
string
|
|
public
|
|
public
array
|
|
public
integer
|
|
public
integer
|
#
getColumnOffset( string $pColumn )
Get a specified AutoFilter Column Offset within the defined AutoFilter range |
public
|
|
public
|
|
public
|
|
public
|
|
public
|
#
shiftColumn( string $fromColumn = NULL, string $toColumn = NULL )
Shift an AutoFilter Column Rule to a different column |
private static
boolean
|
#
_filterTestInSimpleDataSet( mixed $cellValue, mixed[] $dataSet )
Test if cell value is in the defined set of values |
private static
boolean
|
#
_filterTestInDateGroupSet( mixed $cellValue, mixed[] $dataSet )
Test if cell value is in the defined set of Excel date values |
private static
boolean
|
#
_filterTestInCustomDataSet( mixed $cellValue, mixed[] $ruleSet )
Test if cell value is within a set of values defined by a ruleset |
private static
boolean
|
#
_filterTestInPeriodDateSet( mixed $cellValue, mixed[] $monthSet )
Test if cell date value is matches a set of values defined by a set of months |
private
mixed[]
|
#
_dynamicFilterDateRange( string $dynamicRuleType,
Convert a dynamic rule daterange to a custom filter range expression for ease of calculation |
private
|
|
public
|
|
public
|
|
public
|
#
__toString( )
toString method replicates previous behavior by returning the range if object is referenced as a property of its parent. |
private
|
$_workSheet
Autofilter Worksheet |
#
NULL
|
private
string
|
$_range
Autofilter Range |
#
''
|
private
array
|
$_columns
Autofilter Column Ruleset |
#
array()
|
private static
array
|
$_fromReplace
Search/Replace arrays to convert Excel wildcard syntax to a regexp syntax for preg_matching |
#
array('\*', '\?', '~~', '~.*', '~.?')
|
private static
array
|
$_toReplace
|
#
array('.*', '.', '~', '\*', '\?')
|