Overview

Packages

  • JAMA
  • None
  • PHP
  • PHPExcel
    • CachedObjectStorage
    • Calculation
    • Cell
    • Chart
      • Renderer
    • Reader
      • Excel2007
      • Excel5
    • RichText
    • Settings
    • Shared
      • Escher
      • OLE
      • Trend
      • ZipArchive
    • Style
    • Worksheet
      • Drawing
    • Writer
      • 2007
      • CSV
      • Excel2007
      • Excel5
      • HTML
      • PDF

Classes

  • PHPExcel_Worksheet
  • PHPExcel_Worksheet_AutoFilter
  • PHPExcel_Worksheet_AutoFilter_Column
  • PHPExcel_Worksheet_AutoFilter_Column_Rule
  • PHPExcel_Worksheet_BaseDrawing
  • PHPExcel_Worksheet_CellIterator
  • PHPExcel_Worksheet_ColumnDimension
  • PHPExcel_Worksheet_HeaderFooter
  • PHPExcel_Worksheet_HeaderFooterDrawing
  • PHPExcel_Worksheet_MemoryDrawing
  • PHPExcel_Worksheet_PageMargins
  • PHPExcel_Worksheet_PageSetup
  • PHPExcel_Worksheet_Protection
  • PHPExcel_Worksheet_Row
  • PHPExcel_Worksheet_RowDimension
  • PHPExcel_Worksheet_RowIterator
  • PHPExcel_Worksheet_SheetView
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Worksheet_AutoFilter_Column_Rule

PHPExcel_Worksheet_AutoFilter_Column_Rule

Package: PHPExcel\Worksheet
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Worksheet/AutoFilter/Column/Rule.php
Methods summary
public
# __construct( PHPExcel_Worksheet_AutoFilter_Column $pParent = NULL )

Create a new PHPExcel_Worksheet_AutoFilter_Column_Rule

Create a new PHPExcel_Worksheet_AutoFilter_Column_Rule

Parameters

$pParent
public string
# getRuleType( )

Get AutoFilter Rule Type

Get AutoFilter Rule Type

Returns

string
public PHPExcel_Worksheet_AutoFilter_Column
# setRuleType( string $pRuleType = PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_FILTER )

Set AutoFilter Rule Type

Set AutoFilter Rule Type

Parameters

$pRuleType

Returns

PHPExcel_Worksheet_AutoFilter_Column

Throws

PHPExcel_Exception
public string
# getValue( )

Get AutoFilter Rule Value

Get AutoFilter Rule Value

Returns

string
public PHPExcel_Worksheet_AutoFilter_Column_Rule
# setValue( string|string[] $pValue = '' )

Set AutoFilter Rule Value

Set AutoFilter Rule Value

Parameters

$pValue

Returns

PHPExcel_Worksheet_AutoFilter_Column_Rule

Throws

PHPExcel_Exception
public string
# getOperator( )

Get AutoFilter Rule Operator

Get AutoFilter Rule Operator

Returns

string
public PHPExcel_Worksheet_AutoFilter_Column_Rule
# setOperator( string $pOperator = PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL )

Set AutoFilter Rule Operator

Set AutoFilter Rule Operator

Parameters

$pOperator

Returns

PHPExcel_Worksheet_AutoFilter_Column_Rule

Throws

PHPExcel_Exception
public string
# getGrouping( )

Get AutoFilter Rule Grouping

Get AutoFilter Rule Grouping

Returns

string
public PHPExcel_Worksheet_AutoFilter_Column_Rule
# setGrouping( string $pGrouping = NULL )

Set AutoFilter Rule Grouping

Set AutoFilter Rule Grouping

Parameters

$pGrouping

Returns

PHPExcel_Worksheet_AutoFilter_Column_Rule

Throws

PHPExcel_Exception
public PHPExcel_Worksheet_AutoFilter_Column_Rule
# setRule( string $pOperator = PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_COLUMN_RULE_EQUAL, string|string[] $pValue = '', string $pGrouping = NULL )

Set AutoFilter Rule

Set AutoFilter Rule

Parameters

$pOperator
$pValue
$pGrouping

Returns

PHPExcel_Worksheet_AutoFilter_Column_Rule

Throws

PHPExcel_Exception
public PHPExcel_Worksheet_AutoFilter_Column
# getParent( )

Get this Rule's AutoFilter Column Parent

Get this Rule's AutoFilter Column Parent

Returns

PHPExcel_Worksheet_AutoFilter_Column
public PHPExcel_Worksheet_AutoFilter_Column_Rule
# setParent( PHPExcel_Worksheet_AutoFilter_Column $pParent = NULL )

Set this Rule's AutoFilter Column Parent

Set this Rule's AutoFilter Column Parent

Parameters

$pParent

Returns

PHPExcel_Worksheet_AutoFilter_Column_Rule
public
# __clone( )

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

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

Constants summary
string AUTOFILTER_RULETYPE_FILTER
# 'filter'
string AUTOFILTER_RULETYPE_DATEGROUP
# 'dateGroupItem'
string AUTOFILTER_RULETYPE_CUSTOMFILTER
# 'customFilter'
string AUTOFILTER_RULETYPE_DYNAMICFILTER
# 'dynamicFilter'
string AUTOFILTER_RULETYPE_TOPTENFILTER
# 'top10Filter'
string AUTOFILTER_RULETYPE_DATEGROUP_YEAR
# 'year'
string AUTOFILTER_RULETYPE_DATEGROUP_MONTH
# 'month'
string AUTOFILTER_RULETYPE_DATEGROUP_DAY
# 'day'
string AUTOFILTER_RULETYPE_DATEGROUP_HOUR
# 'hour'
string AUTOFILTER_RULETYPE_DATEGROUP_MINUTE
# 'minute'
string AUTOFILTER_RULETYPE_DATEGROUP_SECOND
# 'second'
string AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY
# 'yesterday'
string AUTOFILTER_RULETYPE_DYNAMIC_TODAY
# 'today'
string AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW
# 'tomorrow'
string AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE
# 'yearToDate'
string AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR
# 'thisYear'
string AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER
# 'thisQuarter'
string AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH
# 'thisMonth'
string AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK
# 'thisWeek'
string AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR
# 'lastYear'
string AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER
# 'lastQuarter'
string AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH
# 'lastMonth'
string AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK
# 'lastWeek'
string AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR
# 'nextYear'
string AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER
# 'nextQuarter'
string AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH
# 'nextMonth'
string AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK
# 'nextWeek'
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1
# 'M1'
string AUTOFILTER_RULETYPE_DYNAMIC_JANUARY
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2
# 'M2'
string AUTOFILTER_RULETYPE_DYNAMIC_FEBRUARY
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3
# 'M3'
string AUTOFILTER_RULETYPE_DYNAMIC_MARCH
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4
# 'M4'
string AUTOFILTER_RULETYPE_DYNAMIC_APRIL
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5
# 'M5'
string AUTOFILTER_RULETYPE_DYNAMIC_MAY
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6
# 'M6'
string AUTOFILTER_RULETYPE_DYNAMIC_JUNE
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7
# 'M7'
string AUTOFILTER_RULETYPE_DYNAMIC_JULY
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8
# 'M8'
string AUTOFILTER_RULETYPE_DYNAMIC_AUGUST
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9
# 'M9'
string AUTOFILTER_RULETYPE_DYNAMIC_SEPTEMBER
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10
# 'M10'
string AUTOFILTER_RULETYPE_DYNAMIC_OCTOBER
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11
# 'M11'
string AUTOFILTER_RULETYPE_DYNAMIC_NOVEMBER
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11
string AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12
# 'M12'
string AUTOFILTER_RULETYPE_DYNAMIC_DECEMBER
# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12
string AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1
# 'Q1'
string AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2
# 'Q2'
string AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3
# 'Q3'
string AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4
# 'Q4'
string AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE
# 'aboveAverage'
string AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE
# 'belowAverage'
string AUTOFILTER_COLUMN_RULE_EQUAL
# 'equal'
string AUTOFILTER_COLUMN_RULE_NOTEQUAL
# 'notEqual'
string AUTOFILTER_COLUMN_RULE_GREATERTHAN
# 'greaterThan'
string AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL
# 'greaterThanOrEqual'
string AUTOFILTER_COLUMN_RULE_LESSTHAN
# 'lessThan'
string AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL
# 'lessThanOrEqual'
string AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE
# 'byValue'
string AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT
# 'byPercent'
string AUTOFILTER_COLUMN_RULE_TOPTEN_TOP
# 'top'
string AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM
# 'bottom'
Properties summary
private static array $_ruleTypes
# array( // Currently we're not handling // colorFilter // extLst // iconFilter self::AUTOFILTER_RULETYPE_FILTER, self::AUTOFILTER_RULETYPE_DATEGROUP, self::AUTOFILTER_RULETYPE_CUSTOMFILTER, self::AUTOFILTER_RULETYPE_DYNAMICFILTER, self::AUTOFILTER_RULETYPE_TOPTENFILTER, )
private static array $_dateTimeGroups
# array( self::AUTOFILTER_RULETYPE_DATEGROUP_YEAR, self::AUTOFILTER_RULETYPE_DATEGROUP_MONTH, self::AUTOFILTER_RULETYPE_DATEGROUP_DAY, self::AUTOFILTER_RULETYPE_DATEGROUP_HOUR, self::AUTOFILTER_RULETYPE_DATEGROUP_MINUTE, self::AUTOFILTER_RULETYPE_DATEGROUP_SECOND, )
private static array $_dynamicTypes
# array( self::AUTOFILTER_RULETYPE_DYNAMIC_YESTERDAY, self::AUTOFILTER_RULETYPE_DYNAMIC_TODAY, self::AUTOFILTER_RULETYPE_DYNAMIC_TOMORROW, self::AUTOFILTER_RULETYPE_DYNAMIC_YEARTODATE, self::AUTOFILTER_RULETYPE_DYNAMIC_THISYEAR, self::AUTOFILTER_RULETYPE_DYNAMIC_THISQUARTER, self::AUTOFILTER_RULETYPE_DYNAMIC_THISMONTH, self::AUTOFILTER_RULETYPE_DYNAMIC_THISWEEK, self::AUTOFILTER_RULETYPE_DYNAMIC_LASTYEAR, self::AUTOFILTER_RULETYPE_DYNAMIC_LASTQUARTER, self::AUTOFILTER_RULETYPE_DYNAMIC_LASTMONTH, self::AUTOFILTER_RULETYPE_DYNAMIC_LASTWEEK, self::AUTOFILTER_RULETYPE_DYNAMIC_NEXTYEAR, self::AUTOFILTER_RULETYPE_DYNAMIC_NEXTQUARTER, self::AUTOFILTER_RULETYPE_DYNAMIC_NEXTMONTH, self::AUTOFILTER_RULETYPE_DYNAMIC_NEXTWEEK, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_1, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_2, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_3, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_4, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_5, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_6, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_7, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_8, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_9, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_10, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_11, self::AUTOFILTER_RULETYPE_DYNAMIC_MONTH_12, self::AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_1, self::AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_2, self::AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_3, self::AUTOFILTER_RULETYPE_DYNAMIC_QUARTER_4, self::AUTOFILTER_RULETYPE_DYNAMIC_ABOVEAVERAGE, self::AUTOFILTER_RULETYPE_DYNAMIC_BELOWAVERAGE, )
private static array $_operators
# array( self::AUTOFILTER_COLUMN_RULE_EQUAL, self::AUTOFILTER_COLUMN_RULE_NOTEQUAL, self::AUTOFILTER_COLUMN_RULE_GREATERTHAN, self::AUTOFILTER_COLUMN_RULE_GREATERTHANOREQUAL, self::AUTOFILTER_COLUMN_RULE_LESSTHAN, self::AUTOFILTER_COLUMN_RULE_LESSTHANOREQUAL, )
private static array $_topTenValue
# array( self::AUTOFILTER_COLUMN_RULE_TOPTEN_BY_VALUE, self::AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT, )
private static array $_topTenType
# array( self::AUTOFILTER_COLUMN_RULE_TOPTEN_TOP, self::AUTOFILTER_COLUMN_RULE_TOPTEN_BOTTOM, )
private PHPExcel_Worksheet_AutoFilter_Column $_parent

Autofilter Column

Autofilter Column

# NULL
private string $_ruleType

Autofilter Rule Type

Autofilter Rule Type

# PHPExcel_Worksheet_AutoFilter_Column_Rule::AUTOFILTER_RULETYPE_FILTER
private string $_value

Autofilter Rule Value

Autofilter Rule Value

# ''
private string $_operator

Autofilter Rule Operator

Autofilter Rule Operator

# ''
private string $_grouping

DateTimeGrouping Group Value

DateTimeGrouping Group Value

# ''
Autene API documentation generated by ApiGen