Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearConditionalFormating Method / ClearConditionalFormating(Int32,Int32,Int32,Int32) Method
Starting row index
Starting column index
Number of rows
Number of columns
Example


In This Topic
    ClearConditionalFormating(Int32,Int32,Int32,Int32) Method
    In This Topic
    Removes all the conditional formatting from the specified cell range.
    Syntax
    'Declaration
     
    Public Overloads Sub ClearConditionalFormating( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
     
    instance.ClearConditionalFormating(row, column, rowCount, columnCount)
    public void ClearConditionalFormating( 
       int row,
       int column,
       int rowCount,
       int columnCount
    )

    Parameters

    row
    Starting row index
    column
    Starting column index
    rowCount
    Number of rows
    columnCount
    Number of columns
    Example
    This example clears the formatting.
    private void Form1_Load(object sender, EventArgs e)
            {
                fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
                fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
                fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
                fpSpread1.Sheets[0].Cells[0, 2].Value = 1;
                FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, false);
                unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
                unary.Value = 10;
                unary.BackColor = System.Drawing.Color.Red;
    
                FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule();
                topRank.IsDescending = true;
                topRank.BackColor = System.Drawing.Color.Tomato;
                topRank.ForeColor = System.Drawing.Color.Yellow;
    
                //CondtionalFormatting Constructor
                FarPoint.Win.Spread.ConditionalFormatting cf = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2));
                FarPoint.Win.Spread.ConditionalFormatting cf1 = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary);
                fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf);
                fpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf1);           
            }               
    
            private void button1_Click(object sender, EventArgs e)
            {
                fpSpread1.Sheets[0].ClearConditionalFormating(0, 0);
                //fpSpread1.Sheets[0].ClearConditionalFormating(0, 0, 2, 2);            
            }
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load       
            FpSpread1.Sheets(0).Cells(0, 0).Value = 3
            FpSpread1.Sheets(0).Cells(1, 0).Value = 2
            FpSpread1.Sheets(0).Cells(1, 1).Value = 10
            FpSpread1.Sheets(0).Cells(0, 2).Value = 1
            Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 10, False)
            unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
            unary.Value = 10
            unary.BackColor = Drawing.Color.Red
            unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(FarPoint.Win.Spread.UnderlineFontStyle.None)
    
            Dim topRank As New FarPoint.Win.Spread.TopRankedValuesConditionalFormattingRule()
            topRank.IsDescending = True
            topRank.BackColor = Drawing.Color.Tomato
            topRank.ForeColor = Drawing.Color.Yellow
    
            'CondtionalFormatting Constructor
            Dim cf As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2))
            Dim cf1 As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary)
            FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf)
            FpSpread1.ActiveSheet.Models.ConditionalFormatting.Add(cf1)
    End Sub
    
        Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            'FpSpread1.Sheets(0).ClearConditionalFormating(0, 0)
            FpSpread1.Sheets(0).ClearConditionalFormating(0, 0, 2, 2)
        End Sub
    See Also