PivotValueCellExtra class

Office 2013 and later

Defines the PivotValueCellExtra Class.This class is only available in Office2013. When the object is serialized out as xml, its qualified name is x15:x.

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

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.6.136 CT_PivotValueCellExtra

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotValueCell

A complex type that specifies the server formatting for a CT_PivotValueCell element that is the parent of this element.<112>

Attributes:

in: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies an index to the list of the numeric formats, specified by the pivotTableServerFormats element specified in the extension of a PivotTable ([ISO/IEC-29500-1] section 18.10), specified by the pivotTableReference element in the extension of a workbook as specified by section 2.2.4.10. MUST be a value between 0 and the count attribute of a CT_PivotTableServerFormats element.

bc: An ST_UnsignedIntHex ([ISO/IEC-29500-1] section 18.18.86) attribute that specifies the background color for the CT_PivotValueCell element that is a parent of this element. The color is specified as a HEX value in RGB space.

fc: An ST_UnsignedIntHex ([ISO/IEC-29500-1] section 18.18.86) attribute that specifies the foreground color for the CT_PivotValueCell element that is a parent of this element. The color is specified as a HEX value in RGB space.

i: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the PivotValueCell specified by CT_PivotValueCell that is a parent of this element contains italic formatting. A value of 1 or true indicates this value contains italic formatting on the server.

un: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the PivotValueCell specified by CT_PivotValueCell that is a parent of this element contains underline formatting. A value of 1 or true indicates this value contains underline formatting on the server.

st: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the PivotValueCell specified by CT_PivotValueCell that is a parent of this element contains strikethrough formatting. A value of 1 or true indicates this value contains strikethrough formatting on the server.

b: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the PivotValueCell specified by CT_PivotValueCell that is a parent of this element contains bold formatting. A value of 1 or true indicates this value contains bold formatting on the server.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_PivotValueCellExtra">

<xsd:attribute name="in" type="xsd:unsignedInt" use="optional"/>

<xsd:attribute name="bc" type="x:ST_UnsignedIntHex" use="optional"/>

<xsd:attribute name="fc" type="x:ST_UnsignedIntHex" use="optional"/>

<xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="un" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>

</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: