Share via

2.6.136 CT_PivotValueCellExtra

  • Article

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

Referenced by: CT_PivotValueCell

A complex type that specifies the server formatting (section 2.3.4.1.2) for a CT_PivotValueCell element (section 2.6.135) that is the parent of this element.

Attributes:

in: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies an index to the list of the numeric formats, specified by the pivotTableServerFormats element (section 2.4.2) specified in the extension of a PivotTable ([ISO/IEC29500-1:2016] section 18.10) specified by the pivotTableReference element (section 2.4.1) in the extension of a workbook as specified in section 2.2.4.11. The value MUST be between zero and the count attribute of the CT_PivotTableServerFormats element (section 2.6.137).

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

fc: An ST_UnsignedIntHex ([ISO/IEC29500-1:2016] 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 hexadecimal value in RGB space.

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

un: A Boolean ([XMLSCHEMA2/2] 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/2] 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/2] 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/2] 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/2] section 2.1).