Spread Silverlight Documentation
IExcelGeneralRule Interface Members
Properties 

The following tables list the members exposed by IExcelGeneralRule.

Public Properties
 NameDescription
 PropertyAboveAverageIndicates whether the rule is an "above average" rule. '1' indicates 'above average'. This attribute is ignored if type is not equal to aboveAverage.  
 PropertyBottomIndicates 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.  
 PropertyDifferentialFormattingIdGets or sets the id of the differential formatting which is used to locate the IDifferentialFormatting instance from the workbook.  
 PropertyEqualAverageFlag 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.  
 PropertyFormulasGets or sets the formulas used to evaluates whether this rule should be applied.  
 PropertyOperatorThe operator in the "cell value is" conditional formatting rule. This attribute is ignored if type is not equal to cellIs  
 PropertyPercentIndicates whether the "top/bottom n" rule is a "top/bottom n percent" rule. This attribute is ignored if type is not equal to top10.  
 PropertyRankThe value of "n" in the "top/bottom n" conditional formatting rule. This attribute is ignored if type is not equal to top10.  
 PropertyStdDevThe 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.  
 PropertyTextThe text value in a "text contains" conditional formatting rule. This attribute is ignored if type is not equal to containsText.  
 PropertyTypeType of conditional formatting rule.  
Top
See Also

Reference

IExcelGeneralRule Interface
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.