PHPExcel classes » \PHPExcel_Worksheet_AutoFilter_Column

Methods
Properties

Constants

PHPExcel_Worksheet_AutoFilter_Column_Rule

category	PHPExcel
package	PHPExcel_Worksheet
copyright	Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

Methods

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

__clone()

Create a new PHPExcel_Worksheet_AutoFilter_Column_Rule

__construct(\PHPExcel_Worksheet_AutoFilter_Column $pParent)

Parameters

$pParent

\PHPExcel_Worksheet_AutoFilter_Column

Get AutoFilter Rule Grouping

getGrouping() : string

Returns

string

Get AutoFilter Rule Operator

getOperator() : string

Returns

string

Get this Rule's AutoFilter Column Parent

getParent() : \PHPExcel_Worksheet_AutoFilter_Column

Returns

\PHPExcel_Worksheet_AutoFilter_Column

Get AutoFilter Rule Type

getRuleType() : string

Returns

string

Get AutoFilter Rule Value

getValue() : string

Returns

string

Set AutoFilter Rule Grouping

setGrouping(string $pGrouping) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pGrouping

string

Exceptions

`\PHPExcel_Exception`

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Operator

setOperator(string $pOperator) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pOperator

string

Exceptions

`\PHPExcel_Exception`

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

Set this Rule's AutoFilter Column Parent

setParent(\PHPExcel_Worksheet_AutoFilter_Column $pParent) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pParent

\PHPExcel_Worksheet_AutoFilter_Column

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule

setRule(string $pOperator, string | string[] $pValue, string $pGrouping) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pOperator

string

$pValue

stringstring[]

$pGrouping

string

Exceptions

`\PHPExcel_Exception`

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Type

setRuleType(string $pRuleType) : \PHPExcel_Worksheet_AutoFilter_Column

Parameters

$pRuleType

string

Exceptions

`\PHPExcel_Exception`

Returns

\PHPExcel_Worksheet_AutoFilter_Column

Set AutoFilter Rule Value

setValue(string | string[] $pValue) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pValue

stringstring[]

Exceptions

`\PHPExcel_Exception`

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule

Properties

$_dateTimeGroups

$_dynamicTypes

$_grouping : string

$_operator : string

$_operators

$_parent : \PHPExcel_Worksheet_AutoFilter_Column

$_ruleType : string

$_ruleTypes

$_topTenType

$_topTenValue

$_value : string

Constants

AUTOFILTER_COLUMN_RULE_EQUAL

AUTOFILTER_COLUMN_RULE_EQUAL

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_NOTEQUAL

AUTOFILTER_COLUMN_RULE_NOTEQUAL

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM

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_RULETYPE_CUSTOMFILTER

AUTOFILTER_RULETYPE_CUSTOMFILTER

AUTOFILTER_RULETYPE_DATEGROUP

AUTOFILTER_RULETYPE_DATEGROUP

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_MONTH

AUTOFILTER_RULETYPE_DATEGROUP_MONTH

AUTOFILTER_RULETYPE_DATEGROUP_SECOND

AUTOFILTER_RULETYPE_DATEGROUP_SECOND

AUTOFILTER_RULETYPE_DATEGROUP_YEAR

AUTOFILTER_RULETYPE_DATEGROUP_YEAR

AUTOFILTER_RULETYPE_DYNAMICFILTER

AUTOFILTER_RULETYPE_DYNAMICFILTER

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_APRIL

AUTOFILTER_RULETYPE_DYNAMIC_APRIL

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY

AUTOFILTER_RULETYPE_DYNAMIC_JULY

AUTOFILTER_RULETYPE_DYNAMIC_JULY

AUTOFILTER_RULETYPE_DYNAMIC_JUNE

AUTOFILTER_RULETYPE_DYNAMIC_JUNE

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_MARCH

AUTOFILTER_RULETYPE_DYNAMIC_MARCH

AUTOFILTER_RULETYPE_DYNAMIC_MAY

AUTOFILTER_RULETYPE_DYNAMIC_MAY

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER

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_SEPTEMBER

AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR

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_YESTERDAY

AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY

AUTOFILTER_RULETYPE_FILTER

AUTOFILTER_RULETYPE_FILTER

AUTOFILTER_RULETYPE_TOPTENFILTER

AUTOFILTER_RULETYPE_TOPTENFILTER