Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearConditionalFormating Method / ClearConditionalFormating(Int32,Int32) Method
Row index
Column index
Example


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

    Parameters

    row
    Row index
    column
    Column index
    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