Schema Central > OOXML > sml-sheet.xsd > ssml:cfRule
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

ssml:cfRule

Conditional Formatting Rule

Element information

Type: ssml:CT_CfRule

Properties: Local, Qualified

Content

Attributes

NameOccTypeDescriptionNotes
type [0..1]ssml:ST_CfTypeType
dxfId [0..1]ssml:ST_DxfIdDifferential Formatting Id
priority [1..1]xsd:intPriority
stopIfTrue [0..1]xsd:booleanStop If TrueDefault value is "false".
aboveAverage [0..1]xsd:booleanAbove Or Below AverageDefault value is "true".
percent [0..1]xsd:booleanTop 10 PercentDefault value is "false".
bottom [0..1]xsd:booleanBottom NDefault value is "false".
operator [0..1]ssml:ST_ConditionalFormattingOperatorOperator
text [0..1]xsd:stringText
timePeriod [0..1]ssml:ST_TimePeriodTime Period
rank [0..1]xsd:unsignedIntRank
stdDev [0..1]xsd:intStdDev
equalAverage [0..1]xsd:booleanEqual AverageDefault value is "false".

Used in

Sample instance

<ssml:cfRule priority="1">
   <ssml:formula>string</ssml:formula>
   <ssml:colorScale>
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
      <ssml:color/>
   </ssml:colorScale>
   <ssml:dataBar>
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
      <ssml:color/>
   </ssml:dataBar>
   <ssml:iconSet iconSet="3TrafficLights1">
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
   </ssml:iconSet>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:cfRule>

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to contrib@functx.com