Rule element
Attributes for Rule
CellItemRef
Use: required
Valid values: long
ElementRef
Use: optional
Valid values: string
IgnoreSpecialElements
Use: optional
Valid values: boolean
IsActive
Use: optional
Valid values: boolean
Operator
Use: required
Valid values: Less, LessEqual, Equal, GreaterEqual, Greater
Target
Use: required
Valid values: Row, Column, Cell, RowStats, ColStats
Type
Use: required
Valid values: Hide, Highlight
Value
Use: required
Valid values: double
XML representation
<xs:element name="Rule">
<xs:attribute name="Type" type="RuleConstants" use="required">
<xs:enumeration value="Hide"/>
<xs:enumeration value="Highlight"/>
</xs:attribute>
<xs:attribute name="Target" type="RuleTargetConstants" use="required">
<xs:enumeration value="Row"/>
<xs:enumeration value="Column"/>
<xs:enumeration value="Cell"/>
<xs:enumeration value="RowStats"/>
<xs:enumeration value="ColStats"/>
</xs:attribute>
<xs:attribute name="Operator" type="ComparisonOpConstants" use="required">
<xs:enumeration value="Less"/>
<xs:enumeration value="LessEqual"/>
<xs:enumeration value="Equal"/>
<xs:enumeration value="GreaterEqual"/>
<xs:enumeration value="Greater"/>
</xs:attribute>
<xs:attribute name="Value" type="xs:double" use="required"/>
<xs:attribute name="CellItemRef" type="xs:long" use="required"/>
<xs:attribute name="ElementRef" type="xs:string" use="optional"/>
<xs:attribute default="true" name="IgnoreSpecialElements" type="xs:boolean" use="optional"/>
<xs:attribute default="true" name="IsActive" type="xs:boolean" use="optional"/>
</xs:element>
Parent elements
See also