Spread Windows Forms 11.0 Product Documentation
ClearConditionalFormatings Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : ClearConditionalFormatings Method
Removes all the conditional formatting from the sheet.
Syntax
'Declaration
 
Public Sub ClearConditionalFormatings() 
'Usage
 
Dim instance As SheetView
 
instance.ClearConditionalFormatings()
public void ClearConditionalFormatings()
Remarks
This method removes conditional formats that use rules.
Example
This example uses the ClearConditionalFormatings method.
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.Model.CellRange celRange1 = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3);
FarPoint.Win.Spread.ThreeColorScaleConditionalFormattingRule rule = new FarPoint.Win.Spread.ThreeColorScaleConditionalFormattingRule(Color.Aqua, Color.Bisque, Color.BlueViolet);
fpSpread1.Sheets[0].SetConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] { celRange1 }, rule);

private void button1_Click(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].ClearConditionalFormatings();           
        }
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.Win.Spread.Model.CellRange(0, 0, 3, 3)
Dim rule As New FarPoint.Win.Spread.ThreeColorScaleConditionalFormattingRule(Color.Aqua, Color.Bisque, Color.BlueViolet)
FpSpread1.Sheets(0).SetConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {celRange1}, rule)

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        FpSpread1.Sheets(0).ClearConditionalFormatings()
End Sub
See Also

Reference

SheetView Class
SheetView Members