GrapeCity.Xaml.SpreadSheet.Data
RemoveRule(Int32,Int32,Int32,Int32) Method
Example 


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 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.
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

See Also

Reference

ConditionalFormat Class
ConditionalFormat Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options