RangeProperties Class
Range Grouping Properties.When the object is serialized out as xml, its qualified name is x:rangePr.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.RangeProperties
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Class RangeProperties _
Inherits OpenXmlLeafElement
'Usage
Dim instance As RangeProperties
public class RangeProperties : OpenXmlLeafElement
Remarks
[ISO/IEC 29500-1 1st Edition]
18.10.1.78 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.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.