SharedItems Class

Shared Items.When the object is serialized out as xml, its qualified name is x:sharedItems.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Spreadsheet.SharedItems

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(NumberItem))> _
<ChildElementInfoAttribute(GetType(BooleanItem))> _
<ChildElementInfoAttribute(GetType(MissingItem))> _
<ChildElementInfoAttribute(GetType(ErrorItem))> _
<ChildElementInfoAttribute(GetType(StringItem))> _
<ChildElementInfoAttribute(GetType(DateTimeItem))> _
Public Class SharedItems _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As SharedItems

[ChildElementInfoAttribute(typeof(NumberItem))]
[ChildElementInfoAttribute(typeof(BooleanItem))]
[ChildElementInfoAttribute(typeof(MissingItem))]
[ChildElementInfoAttribute(typeof(ErrorItem))]
[ChildElementInfoAttribute(typeof(StringItem))]
[ChildElementInfoAttribute(typeof(DateTimeItem))]
public class SharedItems : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

• MissingItem <x:m>

• NumberItem <x:n>

• BooleanItem <x:b>

• ErrorItem <x:e>

• StringItem <x:s>

• DateTimeItem <x:d>

[ISO/IEC 29500-1 1st Edition]

18.10.1.90 sharedItems (Shared Items)

Represents the collection of unique items for a field in the PivotCacheDefinition. The sharedItems complex type stores data type and formatting information about the data in a field. Items in the PivotCacheDefinition can be shared in order to reduce the redundancy of those values that are referenced in multiple places across all the PivotTable parts. [Example: A value might be part of a filter, it might appear on a row or column axis, and will appear in the pivotCacheRecords definition as well. However, because of the performance cost of creating the optimized shared items, items are only shared if they are actually in use in the PivotTable. Therefore, depending on user actions on the PivotTable layout, the pivotCacheDefinition and underlying PivotCacheRecords part can be updated. end example]

If there are no shared items, then field values are stored directly in the pivotCacheRecords part.

[Example:

<sharedItems count="1">
<s v="[Customer].[Customer Geography].[Country].&amp;[United States]"
c="United States"/>
</sharedItems>

end example]

The following attributes are not required or used if there are no items in sharedItems.

• containsBlank

• containsSemiMixedTypes

• containsMixedTypes

• longText

The following attributes are not used unless there is more than one item in sharedItems or the one and only item is not a blank item. If the first item is a blank item the data type the field cannot be verified.

• containsNumber

• containsDates

• containsString

• containsInteger

The following attributes can be omitted without loss of functionality.

• containsNonDate

• count

The following attributes are not required and can be omitted. However, refreshing the PivotTable could produce different groupings than before.

• maxDate

• minDate

• maxValue

• minValue

Applications should ensure that “date” attributes are not mixed with “value” attributes.

[Note: The W3C XML Schema definition of this element’s content model (CT_SharedItems) 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.

See Also

Reference

SharedItems Members

DocumentFormat.OpenXml.Spreadsheet Namespace