RemoveRule(FormattingRuleBase) Method

Removes a rule object from the ConditionalFormats object.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub RemoveRule( _
   ByVal rule As FormattingRuleBase _
)

'Usage
 
Dim instance As ConditionalFormat
Dim rule As FormattingRuleBase
 
instance.RemoveRule(rule)

public void RemoveRule( 
   FormattingRuleBase rule
)

Parameters

rule: Rule object to remove from the ConditionalFormats object.

Example

This example removes a rule.

GrapeCity.Windows.SpreadSheet.Data.CellValueRule rule = new GrapeCity.Windows.SpreadSheet.Data.CellValueRule();
        
        private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
            GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
            GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
            GcSpreadSheet1.Sheets[0].Cells[3, 0].Value = -3;
            var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
            style2.Background = new SolidColorBrush(Colors.Yellow);            
            rule.Operator = GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between;
            rule.Style = style2;
            rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
            rule.Value1 = 1;
            rule.Value2 = 8;
            GcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);          
        }

        private void button1_Click_1(object sender, RoutedEventArgs e)
        {
            GcSpreadSheet1.Sheets[0].ConditionalFormats.RemoveRule(rule);
        }

VB.NET

Dim rule As New GrapeCity.Windows.SpreadSheet.Data.CellValueRule()

    Public Sub New()
        InitializeComponent()
        GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
        GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
        GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
        GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = -3
        Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
        style2.Background = New SolidColorBrush(Colors.Yellow)
        rule.Operator = GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between
        rule.Style = style2
        rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
        rule.Value1 = 1
        rule.Value2 = 8
        GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)        
    End Sub  

    Private Sub button1_Click(sender As Object, e As RoutedEventArgs) Handles button1.Click
        GcSpreadSheet1.Sheets(0).ConditionalFormats.RemoveRule(rule)
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

ConditionalFormat Class
ConditionalFormat Members
Overload List