RemoveRule(Int32,Int32,Int32,Int32) Method

Visual Basic
C#

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

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

public void RemoveRule( 
   System.int row,
   System.int column,
   System.int rowCount,
   System.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.

This example removes rules from a block of cells.

C#

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);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.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);
        }

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

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