ConditionalFormat Class
Conditional Formatting.When the object is serialized out as xml, its qualified name is x:conditionalFormat.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.ConditionalFormat
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(PivotAreas))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class ConditionalFormat _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As ConditionalFormat
[ChildElementInfoAttribute(typeof(PivotAreas))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class ConditionalFormat : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
PivotAreas <x:pivotAreas>
ExtensionList <x:extLst>
[ISO/IEC 29500-1 1st Edition]
18.10.1.18 conditionalFormat (Conditional Formatting)
Represents the conditional formatting defined in the PivotTable.
Parent Elements |
|---|
conditionalFormats (§18.10.1.19) |
Child Elements |
Subclause |
|---|---|
extLst (Future Feature Data Storage Area) |
§18.2.10 |
pivotAreas (Pivot Areas) |
§18.10.1.66 |
Attributes |
Description |
|---|---|
priority (Priority) |
Specifies the priority of PivotTable conditional formatting rule. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
scope (Conditional Formatting Scope) |
Specifies the scope of PivotTable conditional formatting rule. The possible values for this attribute are defined by the ST_Scope simple type (§18.18.67). |
type (Conditional Formatting Rule Type) |
Specifies the type of PivotTable conditional formatting rule. See associated simple type definition for details. The possible values for this attribute are defined by the ST_Type simple type (§18.18.84). |
[Note: The W3C XML Schema definition of this element’s content model (CT_ConditionalFormat) 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.