[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

dynamicFilter (Dynamic Filter)

This collection specifies dynamic filter criteria. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the fitler is applied.

[Example:

<filterColumn colId="0">
<dynamicFilter type="today"/>
</filterColumn>

end example]

Parent Elements

filterColumn3.3.2.7)

 

Attributes

Description

maxVal (Max Value)

A maximum value for dynamic filter. It shall be required for today, yesterday, tomorrow, nextWeek, thisWeek, lastWeek, nextMonth, thisMonth, lastMonth, nextQuarter, thisQuarter, lastQuarter, nextYear, thisYear, lastYear, and yearToDate.

 

The above criteria are based on a value range. For example, if today's date is September 22nd, then the range for thisWeek is the values greater than or equal to September 17 and less than September 24. In the thisWeek range, the lower value is expressed using val. The higher value is expressed using maxVal.

 

These dynamic filter shall not require val / maxVal:

Q1, Q2, Q3, Q4,

M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11 and M12.

 

The above criteria shall not specify the range using val and maxVal because Q1 always starts from M1 to M3, and M1 is always January.

 

These types of dynamic filters shall use val and shall not use maxVal:

aboveAverage and belowAverage

 

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

type (Dynamic filter type)

Dynamic filter type, e.g., “today” or “nextWeek”.

 

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

val (Value)

A minimum value for dynamic filter. See description of maxVal to understand when val is required.

 

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

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

<complexType name="CT_DynamicFilter">

   <attribute name="type" type="ST_DynamicFilterType" use="required"/>

   <attribute name="val" type="xsd:double" use="optional"/>

   <attribute name="maxVal" type="xsd:double" use="optional"/>

</complexType>