Partager via


ConditionalFormats Class

Defines the ConditionalFormats Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:conditionalFormats.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.ConditionalFormats

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(ConditionalFormat), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class ConditionalFormats _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As ConditionalFormats
[ChildElementInfoAttribute(typeof(ConditionalFormat), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class ConditionalFormats : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • ConditionalFormat <x14:conditionalFormat>

2.6.49 CT_ConditionalFormats

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

Referenced by: CT_PivotTableDefinition

This complex type specifies a collection of conditional formats applied to the PivotTable ([ISO/IEC-29500-1] section 18.10) view.

Child Elements:

conditionalFormat : A CT_ConditionalFormat element that specifies a conditional formatting applied to the PivotTable ([ISO/IEC-29500-1] section 18.10) view.

Attributes:

count : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of conditionalFormat children of this element.

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

<xsd:complexType name="CT_ConditionalFormats">

<xsd:sequence>

<xsd:element name="conditionalFormat" minOccurs="1" maxOccurs="unbounded" type="CT_ConditionalFormat"/>

</xsd:sequence>

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

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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

ConditionalFormats Members

DocumentFormat.OpenXml.Office2010.Excel Namespace