Gitee
\
admin
login
classes
systemlog
classes
Composer
Autoload
core
dzz
dzz
test
classes
Guzzle
Tests
Service
Description
GuzzleHttp
Command
Exception
Guzzle
Handler
QuerySerializer
RequestLocation
ResponseLocation
Cookie
Exception
Handler
Promise
Psr7
Tests
Command
Guzzle
Asset
Exception
Handler
QuerySerializer
RequestLocation
ResponseLocation
misc
classes
Psr
Http
Message
Qcloud
Cos
Exception
Request
Tests
user
classes
login
classes
profile
classes
register
classes
sso
classes

\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 = 'filter'

AUTOFILTER_RULETYPE_DATEGROUP

AUTOFILTER_RULETYPE_DATEGROUP = 'dateGroupItem'

AUTOFILTER_RULETYPE_CUSTOMFILTER

AUTOFILTER_RULETYPE_CUSTOMFILTER = 'customFilter'

AUTOFILTER_RULETYPE_DYNAMICFILTER

AUTOFILTER_RULETYPE_DYNAMICFILTER = 'dynamicFilter'

AUTOFILTER_RULETYPE_TOPTENFILTER

AUTOFILTER_RULETYPE_TOPTENFILTER = 'top10Filter'

AUTOFILTER_RULETYPE_DATEGROUP_YEAR

AUTOFILTER_RULETYPE_DATEGROUP_YEAR = 'year'

AUTOFILTER_RULETYPE_DATEGROUP_MONTH

AUTOFILTER_RULETYPE_DATEGROUP_MONTH = 'month'

AUTOFILTER_RULETYPE_DATEGROUP_DAY

AUTOFILTER_RULETYPE_DATEGROUP_DAY = 'day'

AUTOFILTER_RULETYPE_DATEGROUP_HOUR

AUTOFILTER_RULETYPE_DATEGROUP_HOUR = 'hour'

AUTOFILTER_RULETYPE_DATEGROUP_MINUTE

AUTOFILTER_RULETYPE_DATEGROUP_MINUTE = 'minute'

AUTOFILTER_RULETYPE_DATEGROUP_SECOND

AUTOFILTER_RULETYPE_DATEGROUP_SECOND = 'second'

AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY

AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY = 'yesterday'

AUTOFILTER_RULETYPE_DYNAMIC_TODAY

AUTOFILTER_RULETYPE_DYNAMIC_TODAY = 'today'

AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW

AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW = 'tomorrow'

AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE

AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE = 'yearToDate'

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR

AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR = 'thisYear'

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER = 'thisQuarter'

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH

AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH = 'thisMonth'

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK

AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK = 'thisWeek'

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR = 'lastYear'

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER = 'lastQuarter'

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH = 'lastMonth'

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK = 'lastWeek'

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR

AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR = 'nextYear'

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER

AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER = 'nextQuarter'

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH

AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH = 'nextMonth'

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK

AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK = 'nextWeek'

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1 = 'M1'

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY

AUTOFILTER_RULETYPE_DYNAMIC_JANUARY = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2 = 'M2'

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY

AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3 = 'M3'

AUTOFILTER_RULETYPE_DYNAMIC_MARCH

AUTOFILTER_RULETYPE_DYNAMIC_MARCH = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4 = 'M4'

AUTOFILTER_RULETYPE_DYNAMIC_APRIL

AUTOFILTER_RULETYPE_DYNAMIC_APRIL = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5 = 'M5'

AUTOFILTER_RULETYPE_DYNAMIC_MAY

AUTOFILTER_RULETYPE_DYNAMIC_MAY = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6 = 'M6'

AUTOFILTER_RULETYPE_DYNAMIC_JUNE

AUTOFILTER_RULETYPE_DYNAMIC_JUNE = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7 = 'M7'

AUTOFILTER_RULETYPE_DYNAMIC_JULY

AUTOFILTER_RULETYPE_DYNAMIC_JULY = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8 = 'M8'

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST

AUTOFILTER_RULETYPE_DYNAMIC_AUGUST = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9 = 'M9'

AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER

AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10 = 'M10'

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER

AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11 = 'M11'

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER

AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12 = 'M12'

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER

AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER = self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1 = 'Q1'

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2 = 'Q2'

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3 = 'Q3'

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4

AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4 = 'Q4'

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE = 'aboveAverage'

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE

AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE = 'belowAverage'

AUTOFILTER_COLUMN_RULE_EQUAL

AUTOFILTER_COLUMN_RULE_EQUAL = 'equal'

AUTOFILTER_COLUMN_RULE_NOTEQUAL

AUTOFILTER_COLUMN_RULE_NOTEQUAL = 'notEqual'

AUTOFILTER_COLUMN_RULE_GREATERTHAN

AUTOFILTER_COLUMN_RULE_GREATERTHAN = 'greaterThan'

AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL

AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL = 'greaterThanOrEqual'

AUTOFILTER_COLUMN_RULE_LESSTHAN

AUTOFILTER_COLUMN_RULE_LESSTHAN = 'lessThan'

AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL

AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL = 'lessThanOrEqual'

AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE

AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE = 'byValue'

AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT

AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT = 'byPercent'

AUTOFILTER_COLUMN_RULE_TOPTEN_TOP

AUTOFILTER_COLUMN_RULE_TOPTEN_TOP = 'top'

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM

AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM = 'bottom'

Properties

$_ruleTypes

$_ruleTypes

$_dateTimeGroups

$_dateTimeGroups

$_dynamicTypes

$_dynamicTypes

$_operators

$_operators

$_topTenValue

$_topTenValue

$_topTenType

$_topTenType

$_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) : mixed

Create a new PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

\PHPExcel_Worksheet_AutoFilter_Column $pParent

Returns

mixed —

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|string[]  $pValue = '') : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule Value

Parameters

string|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|string[]  $pValue = '', string  $pGrouping = NULL) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set AutoFilter Rule

Parameters

string $pOperator
string|string[] $pValue
string $pGrouping

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule —

getParent()

getParent() : \PHPExcel_Worksheet_AutoFilter_Column

Get this Rule's AutoFilter Column Parent

Returns

\PHPExcel_Worksheet_AutoFilter_Column —

setParent()

setParent(\PHPExcel_Worksheet_AutoFilter_Column  $pParent = NULL) : \PHPExcel_Worksheet_AutoFilter_Column_Rule

Set this Rule's AutoFilter Column Parent

Parameters

\PHPExcel_Worksheet_AutoFilter_Column $pParent

Returns

\PHPExcel_Worksheet_AutoFilter_Column_Rule —

__clone()

__clone() : mixed

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

Returns

mixed —