MovingPeriodState class

Office 2013 and later

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.

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office2013.Excel.MovingPeriodState

Namespace:  DocumentFormat.OpenXml.Office2013.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2013)]
public class MovingPeriodState : OpenXmlLeafElement

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).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: