UnaryComparisonConditionalFormattingRule Constructor(UnaryComparisonOperator,String,Boolean)

Initializes a new instance of the UnaryComparisonConditionalFormattingRule class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal operator As UnaryComparisonOperator, _
   ByVal text As String, _
   ByVal isFormula As Boolean _
)

'Usage
 
Dim operator As UnaryComparisonOperator
Dim text As String
Dim isFormula As Boolean
 
Dim instance As New UnaryComparisonConditionalFormattingRule(operator, text, isFormula)

public UnaryComparisonConditionalFormattingRule( 
   UnaryComparisonOperator operator,
   string text,
   bool isFormula
)

Parameters

operator: The @operator.
text: The string value.
isFormula: The boolean value indicates whether the text is a formula.

Example

This example uses a formula to evaluate the value in the rule.

protected void Page_Load(object sender, EventArgs e)
{
    if (this.IsPostBack) return;
    FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
    FpSpread1.Sheets[0].Cells[1, 0].Value = 2;
    FpSpread1.Sheets[0].Cells[1, 1].Value = 4;
    FpSpread1.Sheets[0].Cells[0, 1].Value = 1;   
    //Unary comparison CF
    FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, "=A1+B1", true);
    unary.Formula = "=A1+B1";
    unary.BackColor = System.Drawing.Color.Red;
    unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
    unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;
    FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);      
}

VB.NET

Protected Sub Page_Load(sender As Object, e As EventArgs)
If Me.IsPostBack Then
   Return
End If
FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 4
FpSpread1.Sheets(0).Cells(0, 1).Value = 1
'Unary comparison CF
Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, "=A1+B1", True)
unary.Formula = "=A1+B1"
unary.BackColor = System.Drawing.Color.Red
unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold
FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary)
End Sub

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

Reference

UnaryComparisonConditionalFormattingRule Class
UnaryComparisonConditionalFormattingRule Members
Overload List