Execute Method (PrePaintConditionalFormattingRule)

Executes the conditional format rule for changing the cell's style.

Overload List

Overload	Description
Execute(Object)	Executes the conditional format rule for changing the cell's style.
Execute(Int32,Int32,Object)	Executes the conditional format rule for changing the cell's style.

Example

This example creates a conditional rule.

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;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, false);
unary.Operator = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = Color.Red;
unary.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);

fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary);

FarPoint.Win.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
fpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Win.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, fpSpread1.ActiveSheet.Cells[0, 0].Value);
FarPoint.Win.Spread.StyleInfo source = new FarPoint.Win.Spread.StyleInfo();
fpSpread1.ActiveSheet.Cells[1, 1].Value = 3;
FarPoint.Win.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, fpSpread1.ActiveSheet.Cells[1, 1].Value);        
        }

VB.NET

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
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Unary comparison CF
Dim unary As New FarPoint.Win.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo, 3, False)
unary.[Operator] = FarPoint.Win.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
unary.BackColor = Color.Red
unary.FontStyle = New FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold)

FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, unary)
FpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, unary)

Dim prePaintRule As FarPoint.Win.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Win.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheet.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheet.Cells(0, 0).Value)
Dim source As New FarPoint.Win.Spread.StyleInfo()
FpSpread1.ActiveSheet.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Win.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheet.Cells(1, 1).Value)
    End Sub

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

PrePaintConditionalFormattingRule Class
PrePaintConditionalFormattingRule Members