Execute Method (PrePaintConditionalFormattingRule)

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Function Execute( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Object _
) As PrePaintResult

'Usage
 
Dim instance As PrePaintConditionalFormattingRule
Dim row As Integer
Dim column As Integer
Dim value As Object
Dim value As PrePaintResult
 
value = instance.Execute(row, column, value)

public virtual PrePaintResult Execute( 
   int row,
   int column,
   object value
)

Parameters

row: The row of the cell
column: The column of the cell
value: The value to determine what the result style is.

Return Value

The result after executing the rule.

Example

This example creates a conditional rule.

FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 3);
unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
//unary.Value = 3;
unary.BackColor = 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.Model.CellRange range = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3);
FarPoint.Web.Spread.ConditionalFormatting cfequal = new FarPoint.Web.Spread.ConditionalFormatting(range);
cfequal.Add(unary);

FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfequal);
//FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);
//FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, unary);

FarPoint.Web.Spread.IPrePaintConditionalFormattingRule[] prePaintRule;
FarPoint.Web.Spread.IPrePaintTextConditionalFormattingRule[] prePaintTextRule;
FpSpread1.ActiveSheetView.GetValidConditionalFormat(0, 0, out prePaintRule, out prePaintTextRule);

FarPoint.Web.Spread.PrePaintResult pp = prePaintRule[0].Execute(0, 0, FpSpread1.ActiveSheetView.Cells[0, 0].Value);
FarPoint.Web.Spread.StyleInfo source = new FarPoint.Web.Spread.StyleInfo();
FpSpread1.ActiveSheetView.Cells[1, 1].Value = 3;
FarPoint.Web.Spread.PrePaintResult pp1 = prePaintRule[0].Execute(1, 1, FpSpread1.ActiveSheetView.Cells[1, 1].Value);

VB.NET

Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 3)
unary.[Operator] = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo
'unary.Value = 3;
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 range As New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 3)
Dim cfequal As New FarPoint.Web.Spread.ConditionalFormatting(range)
cfequal.Add(unary)

FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfequal)
'FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);
'FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, unary);

Dim prePaintRule As FarPoint.Web.Spread.IPrePaintConditionalFormattingRule()
Dim prePaintTextRule As FarPoint.Web.Spread.IPrePaintTextConditionalFormattingRule()
FpSpread1.ActiveSheetView.GetValidConditionalFormat(0, 0, prePaintRule, prePaintTextRule)

Dim pp As FarPoint.Web.Spread.PrePaintResult = prePaintRule(0).Execute(0, 0, FpSpread1.ActiveSheetView.Cells(0, 0).Value)
Dim source As New FarPoint.Web.Spread.StyleInfo()
FpSpread1.ActiveSheetView.Cells(1, 1).Value = 3
Dim pp1 As FarPoint.Web.Spread.PrePaintResult = prePaintRule(0).Execute(1, 1, FpSpread1.ActiveSheetView.Cells(1, 1).Value)

Reference

PrePaintConditionalFormattingRule Class
PrePaintConditionalFormattingRule Members