Spread for ASP.NET 7.0 Product Documentation
ClearConditionalFormating(Int32,Int32,Int32,Int32) Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > ClearConditionalFormating Method : ClearConditionalFormating(Int32,Int32,Int32,Int32) Method


row
Starting row index
column
Starting column index
rowCount
Number of rows
columnCount
Number of columns

Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Overloads Sub ClearConditionalFormating( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) 
Visual Basic (Usage)Copy Code
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)
C# 
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.
C#Copy Code
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.NETCopy Code
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.