ssml:CT_CfRule
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Content
- Sequence [1..1]
- ssml:formula [0..3] Formula
- ssml:colorScale [0..1] Color Scale
- ssml:dataBar [0..1] Data Bar
- ssml:iconSet [0..1] Icon Set
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| type | [0..1] | ssml:ST_CfType | Type | |
| dxfId | [0..1] | ssml:ST_DxfId | Differential Formatting Id | |
| priority | [1..1] | xsd:int | Priority | |
| stopIfTrue | [0..1] | xsd:boolean | Stop If True | Default value is "false". |
| aboveAverage | [0..1] | xsd:boolean | Above Or Below Average | Default value is "true". |
| percent | [0..1] | xsd:boolean | Top 10 Percent | Default value is "false". |
| bottom | [0..1] | xsd:boolean | Bottom N | Default value is "false". |
| operator | [0..1] | ssml:ST_ConditionalFormattingOperator | Operator | |
| text | [0..1] | xsd:string | Text | |
| timePeriod | [0..1] | ssml:ST_TimePeriod | Time Period | |
| rank | [0..1] | xsd:unsignedInt | Rank | |
| stdDev | [0..1] | xsd:int | StdDev | |
| equalAverage | [0..1] | xsd:boolean | Equal Average | Default value is "false". |
Used by
- Element ssml:cfRule