Compartir a través de


ConditionalFormattings Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

The following table lists the possible child types:

  • ConditionalFormatting <x14:conditionalFormatting>

2.4.4 conditionalFormattings

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

A CT_ConditionalFormattings element that specifies conditional formatting information for the worksheet. See Worksheet under Extensions by Part for how this element integrates with [ISO/IEC-29500-1].

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

<xsd:element name="conditionalFormattings" type="CT_ConditionalFormattings"/>

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

2.6.1 CT_ConditionalFormattings

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

Referenced by: conditionalFormattings

This complex type specifies conditional formatting information for the worksheet.

Child Elements:

conditionalFormatting : A CT_ConditionalFormatting element that specifies the conditional formatting properties for a range.

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

<xsd:complexType name="CT_ConditionalFormattings">

<xsd:sequence>

<xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

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

ConditionalFormattings Members

DocumentFormat.OpenXml.Office2010.Excel Namespace