RemoveRule(Int32,Int32,Int32,Int32) Method

Removes the rules for a specified cell range.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub RemoveRule( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

'Usage
 
Dim instance As ConditionalFormat
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.RemoveRule(row, column, rowCount, columnCount)

public void RemoveRule( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row: The row index of the first cell in the range.
column: The column index of the first cell in the range.
rowCount: The number of rows in the range.
columnCount: The number of columns in the range.

Example

This example removes a rule from a block of cells.

C#
VB.NET

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.Xaml.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
           
        private void button1_Click_1(object sender, RoutedEventArgs e)
        {
            GcSpreadSheet1.Sheets[0].ConditionalFormats.RemoveRule(1, 0, 2, 1);
        }

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.Xaml.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)})

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

Requirements

Target Platforms: Windows Server 2012, Windows RT

Reference

ConditionalFormat Class
ConditionalFormat Members
Overload List