Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_CfRule
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-sheet_xsd Drilldown into iconSet in schema sml-sheet_xsd Drilldown into dataBar in schema sml-sheet_xsd Drilldown into colorScale in schema sml-sheet_xsd Drilldown into formula in schema sml-sheet_xsd Drilldown into equalAverage in schema sml-sheet_xsd Drilldown into stdDev in schema sml-sheet_xsd Drilldown into rank in schema sml-sheet_xsd Drilldown into timePeriod in schema sml-sheet_xsd Drilldown into text in schema sml-sheet_xsd Drilldown into operator in schema sml-sheet_xsd Drilldown into bottom in schema sml-sheet_xsd Drilldown into percent in schema sml-sheet_xsd Drilldown into aboveAverage in schema sml-sheet_xsd Drilldown into stopIfTrue in schema sml-sheet_xsd Drilldown into priority in schema sml-sheet_xsd Drilldown into dxfId in schema sml-sheet_xsd Drilldown into type in schema sml-sheet_xsdXSD Diagram of CT_CfRule in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_CfRule">
    <xsd:sequence>
        <xsd:element name="formula" type="ST_Formula" minOccurs="0" maxOccurs="3">
            <xsd:annotation>
                <xsd:documentation>Formula</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colorScale" type="CT_ColorScale" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Color Scale</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dataBar" type="CT_DataBar" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Data Bar</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="iconSet" type="CT_IconSet" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Icon Set</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="type" type="ST_CfType">
        <xsd:annotation>
            <xsd:documentation>Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dxfId" type="ST_DxfId" use="optional">
        <xsd:annotation>
            <xsd:documentation>Differential Formatting Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="priority" type="xsd:int" use="required">
        <xsd:annotation>
            <xsd:documentation>Priority</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stopIfTrue" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Stop If True</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="aboveAverage" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Above Or Below Average</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="percent" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Top 10 Percent</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="bottom" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Bottom N</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="operator" type="ST_ConditionalFormattingOperator" use="optional">
        <xsd:annotation>
            <xsd:documentation>Operator</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="text" type="xsd:string" use="optional">
        <xsd:annotation>
            <xsd:documentation>Text</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="timePeriod" type="ST_TimePeriod" use="optional">
        <xsd:annotation>
            <xsd:documentation>Time Period</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rank" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Rank</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDev" type="xsd:int" use="optional">
        <xsd:annotation>
            <xsd:documentation>StdDev</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="equalAverage" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Equal Average</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
formula nsM:formula 0 3
colorScale nsM:colorScale 0 1
dataBar nsM:dataBar 0 1
iconSet nsM:iconSet 0 1
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
type nsM:type (Optional)
dxfId nsM:dxfId Optional
priority nsM:priority Required
stopIfTrue nsM:stopIfTrue false Optional
aboveAverage nsM:aboveAverage true Optional
percent nsM:percent false Optional
bottom nsM:bottom false Optional
operator nsM:operator Optional
text nsM:text Optional
timePeriod nsM:timePeriod Optional
rank nsM:rank Optional
stdDev nsM:stdDev Optional
equalAverage nsM:equalAverage false Optional
Collapse Derivation Tree:
Collapse References:
nsM:cfRule
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0