Freigeben über


RangeProperties-Klasse

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

Vererbungshierarchie

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

Hinweise

[ISO/IEC 29500-1 1. Ausgabe]

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. Die oben aufgeführten Textauszüge wurden von Microsoft (und/oder den Microsoft-Vendoren) von Englisch nach Deutsch übersetzt, und im Rahmen von ISO wird keinerlei Verantwortung für diese Übersetzungen übernommen.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.

Siehe auch

Referenz

RangeProperties-Member

DocumentFormat.OpenXml.Spreadsheet-Namespace