Spread WPF Documentation
ExcelGeneralRule Class Members
Properties 


GrapeCity.Excel Namespace : ExcelGeneralRule Class

The following tables list the members exposed by ExcelGeneralRule.

Public Constructors
 NameDescription
Public ConstructorExcelGeneralRule ConstructorInitializes a new instance of the ExcelGeneralRule class.  
Top
Public Properties
 NameDescription
Public PropertyAboveAverageIndicates whether the rule is an "above average" rule. '1' indicates 'above average'. This attribute is ignored if type is not equal to aboveAverage.  
Public 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.  
Public PropertyDifferentialFormattingIdGets or sets the DXF id used to locate the IDifferentialFormatting from the workbook.  
Public 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.  
Public PropertyFormulasGets or sets the formulas used to evaluates whether this rule should be applied.  
Public PropertyOperatorThe operator in the "cell value is" conditional formatting rule. This attribute is ignored if type is not equal to cellIs  
Public 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.  
Public PropertyPriorityThe 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.  
Public PropertyRankThe value of "n" in the "top/bottom n" conditional formatting rule. This attribute is ignored if type is not equal to top10.  
Public 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.  
Public PropertyStopIfTrueFlag indicates whether apply other lower priority rules when this rule evaluates to true.  
Public PropertyTextThe text value in a "text contains" conditional formatting rule. This attribute is ignored if type is not equal to containsText.  
Public PropertyTypeType of conditional formatting rule.  
Top
See Also

Reference

ExcelGeneralRule Class
GrapeCity.Excel Namespace

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page