\PHPExcel_Worksheet_AutoFilter_Column_Rule

PHPExcel_Worksheet_AutoFilter_Column_Rule

Summary

Methods
Properties
Constants
__construct()
getRuleType()
setRuleType()
getValue()
setValue()
getOperator()
setOperator()
getGrouping()
setGrouping()
setRule()
getParent()
setParent()
__clone()
No public properties found
AUTOFILTER_RULETYPE_FILTER
AUTOFILTER_RULETYPE_DATEGROUP
AUTOFILTER_RULETYPE_CUSTOMFILTER
AUTOFILTER_RULETYPE_DYNAMICFILTER
AUTOFILTER_RULETYPE_TOPTENFILTER
AUTOFILTER_RULETYPE_DATEGROUP_YEAR
AUTOFILTER_RULETYPE_DATEGROUP_MONTH
AUTOFILTER_RULETYPE_DATEGROUP_DAY
AUTOFILTER_RULETYPE_DATEGROUP_HOUR
AUTOFILTER_RULETYPE_DATEGROUP_MINUTE
AUTOFILTER_RULETYPE_DATEGROUP_SECOND
AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY
AUTOFILTER_RULETYPE_DYNAMIC_TODAY
AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW
AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE
AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR
AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER
AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH
AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK
AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR
AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER
AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH
AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK
AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR
AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER
AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH
AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1
AUTOFILTER_RULETYPE_DYNAMIC_JANUARY
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2
AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3
AUTOFILTER_RULETYPE_DYNAMIC_MARCH
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4
AUTOFILTER_RULETYPE_DYNAMIC_APRIL
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5
AUTOFILTER_RULETYPE_DYNAMIC_MAY
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6
AUTOFILTER_RULETYPE_DYNAMIC_JUNE
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7
AUTOFILTER_RULETYPE_DYNAMIC_JULY
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8
AUTOFILTER_RULETYPE_DYNAMIC_AUGUST
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9
AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10
AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11
AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER
AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12
AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER
AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1
AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2
AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3
AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4
AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE
AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE
AUTOFILTER_COLUMN_RULE_EQUAL
AUTOFILTER_COLUMN_RULE_NOTEQUAL
AUTOFILTER_COLUMN_RULE_GREATERTHAN
AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL
AUTOFILTER_COLUMN_RULE_LESSTHAN
AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL
AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE
AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM
No protected methods found
No protected properties found
N/A
No private methods found
$_ruleTypes
$_dateTimeGroups
$_dynamicTypes
$_operators
$_topTenValue
$_topTenType
$_parent
$_ruleType
$_value
$_operator
$_grouping
N/A

Constants

AUTOFILTER_RULETYPE_FILTER

AUTOFILTER_RULETYPE_FILTER

AUTOFILTER_RULETYPE_DATEGROUP

AUTOFILTER_RULETYPE_DATEGROUP

AUTOFILTER_RULETYPE_CUSTOMFILTER

AUTOFILTER_RULETYPE_CUSTOMFILTER

AUTOFILTER_RULETYPE_DYNAMICFILTER

AUTOFILTER_RULETYPE_DYNAMICFILTER

AUTOFILTER_RULETYPE_TOPTENFILTER

AUTOFILTER_RULETYPE_TOPTENFILTER

AUTOFILTER_RULETYPE_DATEGROUP_YEAR

AUTOFILTER_RULETYPE_DATEGROUP_YEAR

AUTOFILTER_RULETYPE_DATEGROUP_MONTH

AUTOFILTER_RULETYPE_DATEGROUP_MONTH

AUTOFILTER_RULETYPE_DATEGROUP_DAY

AUTOFILTER_RULETYPE_DATEGROUP_DAY

AUTOFILTER_RULETYPE_DATEGROUP_HOUR

AUTOFILTER_RULETYPE_DATEGROUP_HOUR

AUTOFILTER_RULETYPE_DATEGROUP_MINUTE

AUTOFILTER_RULETYPE_DATEGROUP_MINUTE

AUTOFILTER_RULETYPE_DATEGROUP_SECOND

AUTOFILTER_RULETYPE_DATEGROUP_SECOND

AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY

AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY

AUTOFILTER_RULETYPE_DYNAMIC_TODAY

AUTOFILTER_RULETYPE_DYNAMIC_TODAY

AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW

AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW

AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE

AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MARCH

AUTOFILTER_RULETYPE_DYNAMIC_MARCH

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_APRIL

AUTOFILTER_RULETYPE_DYNAMIC_APRIL

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MAY

AUTOFILTER_RULETYPE_DYNAMIC_MAY

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_JUNE

AUTOFILTER_RULETYPE_DYNAMIC_JUNE

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_JULY

AUTOFILTER_RULETYPE_DYNAMIC_JULY

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER

AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE

AUTOFILTER_COLUMN_RULE_EQUAL

AUTOFILTER_COLUMN_RULE_EQUAL

AUTOFILTER_COLUMN_RULE_NOTEQUAL

AUTOFILTER_COLUMN_RULE_NOTEQUAL

AUTOFILTER_COLUMN_RULE_GREATERTHAN

AUTOFILTER_COLUMN_RULE_GREATERTHAN

AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL

AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL

AUTOFILTER_COLUMN_RULE_LESSTHAN

AUTOFILTER_COLUMN_RULE_LESSTHAN

AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL

AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL

AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE

AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE

AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT

AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT

AUTOFILTER_COLUMN_RULE_TOPTEN_TOP

AUTOFILTER_COLUMN_RULE_TOPTEN_TOP

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM

Properties

$_ruleTypes

$_ruleTypes : 

Type

$_dateTimeGroups

$_dateTimeGroups : 

Type

$_dynamicTypes

$_dynamicTypes : 

Type

$_operators

$_operators : 

Type

$_topTenValue

$_topTenValue : 

Type

$_topTenType

$_topTenType : 

Type

$_ruleType

$_ruleType : string

Autofilter Rule Type

Type

string

$_value

$_value : string

Autofilter Rule Value

Type

string

$_operator

$_operator : string

Autofilter Rule Operator

Type

string

$_grouping

$_grouping : string

DateTimeGrouping Group Value

Type

string

Methods

__construct()

__construct(\PHPExcel_Worksheet_AutoFilter_Column  $pParent = NULL) 

Create a new PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

\PHPExcel_Worksheet_AutoFilter_Column $pParent

getRuleType()

getRuleType() : string

Get AutoFilter Rule Type

Returns

string

setRuleType()

setRuleType(string  $pRuleType = self::AUTOFILTER_RULETYPE_FILTER) : \PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Rule Type

Parameters

string $pRuleType

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column

getValue()

getValue() : string

Get AutoFilter Rule Value

Returns

string

setValue()

setValue(string|array<mixed,string>  $pValue = '') : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Value

Parameters

string|array<mixed,string> $pValue

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

getOperator()

getOperator() : string

Get AutoFilter Rule Operator

Returns

string

setOperator()

setOperator(string  $pOperator = self::AUTOFILTER_COLUMN_RULE_EQUAL) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Operator

Parameters

string $pOperator

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

getGrouping()

getGrouping() : string

Get AutoFilter Rule Grouping

Returns

string

setGrouping()

setGrouping(string  $pGrouping = NULL) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Grouping

Parameters

string $pGrouping

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

setRule()

setRule(string  $pOperator = self::AUTOFILTER_COLUMN_RULE_EQUAL, string|array<mixed,string>  $pValue = '', string  $pGrouping = NULL) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule

Parameters

string $pOperator
string|array<mixed,string> $pValue
string $pGrouping

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.