Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / ClearConditionalFormatings Method
Example


In This Topic
    ClearConditionalFormatings Method
    In This Topic
    Removes all of the conditional formatting from the sheet.
    Syntax
    'Declaration
     
    Public Sub ClearConditionalFormatings() 
    'Usage
     
    Dim instance As SheetView
     
    instance.ClearConditionalFormatings()
    public void ClearConditionalFormatings()
    Example
    This example uses the ClearConditionalFormatings method.
    protected void Page_Load(object sender, System.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.Web.Spread.Model.CellRange celRange1 = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3);
    FarPoint.Web.Spread.ThreeColorScaleConditionalFormattingRule rule = new FarPoint.Web.Spread.ThreeColorScaleConditionalFormattingRule(Color.Aqua, Color.Bisque, Color.BlueViolet);
    FpSpread1.Sheets[0].SetConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange[] { celRange1 }, rule);         
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {
    FpSpread1.Sheets[0].ClearConditionalFormatings();
    }
    Private Sub Page_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 celRange1 As New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3)
    Dim rule As New FarPoint.Web.Spread.ThreeColorScaleConditionalFormattingRule(Drawing.Color.Aqua, Drawing.Color.Bisque, Drawing.Color.BlueViolet)
    FpSpread1.Sheets(0).SetConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange() {celRange1}, rule)
    End Sub
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    FpSpread1.Sheets(0).ClearConditionalFormatings()           
    End Sub
    See Also