Spread WPF Documentation
AddFormulaRule Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > ConditionalFormat Class : AddFormulaRule Method
The condition formula.
The style that is applied to the cell when the condition is met.
The cell ranges where the rule is applied.
Adds the formula rule to the rule collection.
Syntax
'Declaration
 
Public Function AddFormulaRule( _
   ByVal formula As System.String, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As FormulaRule
'Usage
 
Dim instance As ConditionalFormat
Dim formula As System.String
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As FormulaRule
 
value = instance.AddFormulaRule(formula, style, ranges)
public FormulaRule AddFormulaRule( 
   System.string formula,
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

formula
The condition formula.
style
The style that is applied to the cell when the condition is met.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new formula rule.
Example
This example creates a formula rule.
GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
GcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 1;
GcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 1;
GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 1;
var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 1
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 1
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, New GrapeCity.Windows.SpreadSheet.Data.CellRange() { New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
See Also

Reference

ConditionalFormat Class
ConditionalFormat Members