Executes the conditional format rule for changing the cell's style.
Syntax
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.
C# | Copy Code |
---|
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 | Copy Code |
---|
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) |
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