[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

filters (Filter Criteria)

When multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together.

[Example:

<filters>
<dateGroupItem year="2006" month="1" day="2" dateTimeGrouping="day"/>
<dateGroupItem year="2005" month="1" day="2" dateTimeGrouping="day"/>
</filters>

end example]

Parent Elements

filterColumn3.3.2.7)

 

Child Elements

Subclause

dateGroupItem (Date Grouping)

§3.3.2.4

filter (Filter)

§3.3.2.6

 

Attributes

Description

blank (Filter by Blank)

Flag indicating whether to filter by blank.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

calendarType (Calendar Type)

Calendar type for date grouped items. Used to interpret the values in dateGroupItem. This is the calendar type used to evaluate all dates in the filter column, even when those dates are not using the same calendar system / date formatting.

 

The possible values for this attribute are defined by the ST_CalendarType simple type (§3.18.5).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Filters">

   <sequence>

   <element name="filter" type="CT_Filter" minOccurs="0" maxOccurs="unbounded"/>

   <element name="dateGroupItem" type="CT_DateGroupItem" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

   <attribute name="blank" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="calendarType" type="ST_CalendarType" use="optional" default="none"/>

</complexType>