FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > PrePaintConditionalFormattingRule Class : Execute Method |
'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)
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);
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)
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