GrapeCity.Xaml.SpreadSheet.Data
AddFormulaRule Method
Example 


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 String, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As FormulaRule
'Usage
 
Dim instance As ConditionalFormat
Dim formula As String
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As FormulaRule
 
value = instance.AddFormulaRule(formula, style, ranges)
public FormulaRule AddFormulaRule( 
   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.Xaml.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() { New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ConditionalFormat Class
ConditionalFormat Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options