Spread WPF Documentation
RemoveRule(Int32,Int32,Int32,Int32) Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > ConditionalFormat Class > RemoveRule Method : RemoveRule(Int32,Int32,Int32,Int32) Method
The row index of the first cell in the range.
The column index of the first cell in the range.
The number of rows in the range.
The number of columns in the range.
Removes the rules for a specified cell range.
Syntax
'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.
Example
This example removes rules from a block of cells.
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);
        }
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
See Also

Reference

ConditionalFormat Class
ConditionalFormat Members
Overload List