RangeProperties class

Office 2013 and later

Range Grouping Properties. When the object is serialized out as xml, its qualified name is x:rangePr.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class RangeProperties : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

rangePr (Range Grouping Properties)

Represents the collection of range grouping properties.

[Example:

<rangePr groupBy="months" startDate="2002-01-01T00:00:00"   endDate="2006-05-06T00:00:00"/>

end example]

Parent Elements

fieldGroup (§18.10.1.30)

Attributes

Description

autoEnd (Source Data Ending Range)

Specifies a boolean value that indicates whether the application uses the source data to set the ending range value.

A value of 1 or true indicates the ending range value is set from the source data.

A value of 0 or false indicates ending range values are set by the value specified in endDate or endNum.

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

autoStart (Source Data Set Beginning Range)

Specifies a boolean value that indicates whether we use source data to set the beginning range value.

A value of 1 or true indicates the beginning range value is set from the source data.

A value of 0 or false indicates the beginning range value is set from the value specified in startDate or startNum.

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

endDate (Date Grouping End Value)

Specifies the ending value for date grouping if autoEnd is false.

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

endNum (Numeric Grouping End Value)

Specifies the ending value for numeric grouping if autoEnd is false.

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

groupBy (Group By)

Specifies the grouping.

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

groupInterval (Grouping Interval)

Specifies the grouping interval for numeric range grouping. Specifies the number of days to group by in date range grouping.

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

startDate (Date Grouping Start Value)

Specifies the starting value for date grouping if autoStart is false.

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

startNum (Numeric Grouping Start Value)

Specifies the starting value for numeric grouping if autoStart is false.

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

[Note: The W3C XML Schema definition of this element’s content model (CT_RangePr) is located in §A.2. end note]

© ISO/IEC29500: 2008.

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: