Spread WPF Documentation
IExcelGeneralRule Interface Properties

GrapeCity.Excel Namespace : IExcelGeneralRule Interface

For a list of all members of this type, see IExcelGeneralRule members.

Public Properties
 NameDescription
 PropertyIndicates whether the rule is an "above average" rule. '1' indicates 'above average'. This attribute is ignored if type is not equal to aboveAverage.  
 PropertyIndicates whether the "top/bottom n" rule is a "bottom n" rule. '1' indicates 'bottom'. This attribute is ignored if type is not equal to top10.  
 PropertyGets or sets the id of the differential formatting which is used to locate the IDifferentialFormatting instance from the workbook.  
 PropertyFlag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value. '1' indicates to include the average value in the criteria. This attribute is ignored if type is not equal to aboveAverage.  
 PropertyGets or sets the formulas used to evaluates whether this rule should be applied.  
 PropertyThe operator in the "cell value is" conditional formatting rule. This attribute is ignored if type is not equal to cellIs  
 PropertyIndicates whether the "top/bottom n" rule is a "top/bottom n percent" rule. This attribute is ignored if type is not equal to top10.  
 PropertyThe priority of the conditional formatting rule. The value is used to determine which format should be evaluated and rendered. Lower numeric values are higher priority than higher numeric values. where '1' is the highest priority. (Inherited from GrapeCity.Excel.IExcelConditionalFormatRule)
 PropertyThe value of "n" in the "top/bottom n" conditional formatting rule. This attribute is ignored if type is not equal to top10.  
 PropertyThe number of standard deviations to include above or below the average in the conditional formatting rule. This attribute is ignored if type is not equal to aboveAverage. If a value is present for stdDev and the rule type = aboveAverage, then this rule is automatically an "above or below N standard deviations" rule.  
 PropertyFlag indicates whether apply other lower priority rules when this rule evaluates to true. (Inherited from GrapeCity.Excel.IExcelConditionalFormatRule)
 PropertyThe text value in a "text contains" conditional formatting rule. This attribute is ignored if type is not equal to containsText.  
 PropertyType of conditional formatting rule.  
Top
See Also

Reference

IExcelGeneralRule Interface
GrapeCity.Excel Namespace