MovingPeriodState class
Defines the MovingPeriodState Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is x15:movingPeriodState.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2013.Excel.MovingPeriodState
Namespace: DocumentFormat.OpenXml.Office2013.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
2.4.66 movingPeriodState
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main
A CT_MovingPeriodState element (section 2.6.140) that specifies the current state of the moving period associated with a Pivot Filter ([ISO/IEC-29500-1] section 18.10.1.33) specified by the CT_PivotFilter element ([ISO/IEC-29500-4] section A.2). This element MUST exist only if the type attribute of the parent filter element is one of the following:
Enumeration Value | Description |
dateBetween (Date Between) | Indicates the "between" filter for date values. |
dateEqual (Date Equals) | Indicates the "equals" filter for date values. |
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="movingPeriodState" type="CT_MovingPeriodState"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.140 CT_MovingPeriodState
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: movingPeriodState, CT_TimelineState
The CT_MovingPeriodState complex type specifies the current state of a moving period associated with the filter criteria of a Timeline (section 2.3.5) or a Pivot Filter ([ISO/IEC-29500-1] section 18.10.1.33).
Attributes:
referenceDateBegin: A dateTime attribute ([XMLSCHEMA2] section 3.2.7) that specifies the date when the filter criteria of a Timeline or a Pivot Filter was last advanced.
referencePeriod: An ST_MovingPeriodStep attribute (section 2.7.27) that specifies the granularity of the interval at the end of which the filter criteria of a Timeline or a Pivot Filter will be advanced.
referenceMultiple: An unsignedInt attribute ([XMLSCHEMA2] section 3.3.22) that specifies the number of times the interval specified by referencePeriod attribute will be multiplied to get the actual period at the end of which the filter criteria of a Timeline or a Pivot Filter will be advanced. This value MUST be equal to one.
movingPeriod: An ST_MovingPeriodStep attribute that specifies the granularity of the duration by which the filter criteria of a Timeline or a Pivot Filter will be advanced.
movingMultiple: An unsignedInt attribute ([XMLSCHEMA2] section 3.3.22) that specifies the number of times the duration specified by the movingPeriod attribute will be multiplied to get the actual duration by which the filter criteria of a Timeline or a Pivot Filter will be advanced. This value MUST be equal to one.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_MovingPeriodState">
<xsd:attribute name="referenceDateBegin" type="xsd:dateTime" use="required"/>
<xsd:attribute name="referencePeriod" type="ST_MovingPeriodStep" use="required"/>
<xsd:attribute name="referenceMultiple" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="movingPeriod" type="ST_MovingPeriodStep" use="required"/>
<xsd:attribute name="movingMultiple" type="xsd:unsignedInt" use="required"/>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).