| Name | Description | |
|---|---|---|
 | FormulaRule Constructor | Constructs a formula rule. |
The following tables list the members exposed by FormulaRule.
Public Constructors
Protected Fields
| Name | Description | |
|---|---|---|
 | condition | Indicates the base condition of the rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
Public Properties
| Name | Description | |
|---|---|---|
 | Formula | Gets the comparison formula of the text rule. |
| Priority | Gets the priority of this conditional formatting rule. The value is used to determine which format should be evaluated and rendered. Lower numeric values have a higher priority than higher numeric values. The highest priority is 1. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| Ranges | Gets the cell range collection for the rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| StopIfTrue | Gets or sets whether rules with lower priority are applied over this rule. If this property is true and this rule evaluates to true, no rules with lower priority are applied over this rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| Style | Gets or sets the style for the rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
Public Methods
| Name | Description | |
|---|---|---|
 | Clone | Overridden. Creates a new object that is a copy of the current instance. |
| Contains | Determines whether the range of cells contains the cell at the specified row and column. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
 | Create | Creates a new formula rule with specified parameters. |
| Evaluate | Returns the cell style of the rule if the cell satisfies the condition. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
Protected Methods
| Name | Description | |
|---|---|---|
 | CreateCondition | Overridden. Creates conditions for the rule. |
| GetExpected | Gets the style of the base rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| InitCondition | Initial condition for the rule. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| OnPropertyChanged | Raises the event when the property is changed. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
| OnReadXml | Overridden. Generates the rule from its XML representation. |
| OnWriteXml | Overridden. Converts the rule into its XML representation. |
| Reset | Overridden. Resets the rule |
Public Events
| Name | Description | |
|---|---|---|
 | PropertyChanged | Occurs when a property value changes. (Inherited from GrapeCity.Windows.SpreadSheet.Data.FormattingRuleBase) |
See Also