ClearConditionalFormating(Int32,Int32,Int32,Int32) Method

Removes all of the conditional formatting from the specified cell range.

Syntax

Visual Basic
C#

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

protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            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.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10);
            unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
            unary.Value = 10;
            unary.BackColor = System.Drawing.Color.Red;
            unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
            unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;

            FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule();
            topRank.IsDescending = true;
            topRank.BackColor = System.Drawing.Color.Tomato;
            topRank.ForeColor = System.Drawing.Color.Yellow;

            //CondtionalFormatting Construtor
            FarPoint.Web.Spread.ConditionalFormatting cf = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2));
            FarPoint.Web.Spread.ConditionalFormatting cf1 = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary);
            FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf);
            FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf1);           
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            FpSpread1.Sheets[0].ClearConditionalFormating(0, 0);
            //FpSpread1.Sheets[0].ClearConditionalFormating(0, 0, 2, 2);
        }

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If (IsPostBack) Then
            Return
        End If        
        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.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10)
        unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo
        unary.Value = 10
        unary.BackColor = Drawing.Color.Red
        unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
        unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold

        Dim topRank As New FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule()
        topRank.IsDescending = True
        topRank.BackColor = Drawing.Color.Tomato
        topRank.ForeColor = Drawing.Color.Yellow

        'CondtionalFormatting Construtor
        Dim cf As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2))
        Dim cf1 As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary)
        FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf)
        FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf1)
    End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        FpSpread1.Sheets(0).ClearConditionalFormating(0, 0)
        'FpSpread1.Sheets(0).ClearConditionalFormating(0, 0, 2, 2)
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
Overload List