Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / UnaryComparisonOperator Enumeration
Example Example


In This Topic
    UnaryComparisonOperator Enumeration
    In This Topic
    Represents the unary comparison operator.
    Syntax
    'Declaration
     
    Public Enum UnaryComparisonOperator 
       Inherits System.Enum
    'Usage
     
    Dim instance As UnaryComparisonOperator
    public enum UnaryComparisonOperator : System.Enum 
    Members
    MemberDescription
    EqualToDetermines whether a value is equal to the parameter value
    GreaterThanDetermines whether a value is greater than the parameter value
    GreaterThanOrEqualToDetermines whether a value is greater than or equal to the parameter value
    LessThanDetermines whether a value is less than the parameter value
    LessThanOrEqualToDetermines whether a value is less than or equal to the parameter value
    NotEqualToDetermines whether a value is not equal to the parameter value
    Example
    This example uses the UnaryComparisonOperator enumeration.
    protected void Page_Load(object sender, System.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;              
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo,10);
                unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
                unary.Value = 10;
                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.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule();
                topRank.IsDescending = true;
                topRank.BackColor = Color.Tomato;
                topRank.ForeColor = Color.Yellow;
    
                //CondtionalFormatting Construtor
                FarPoint.Web.Spread.ConditionalFormatting cf = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2));
                FarPoint.Web.Spread.ConditionalFormatting cf1 = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary);
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf);
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf1);
                //OR
                //SetConditionalFormatting Overload
                //FpSpread1.ActiveSheetView.SetConditionalFormatting(cf, cf1);
            }
    
    Private Sub Page_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
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10)
                unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo
                unary.Value = 10
                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 topRank As New FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule()
                topRank.IsDescending = True
                topRank.BackColor = Drawing.Color.Tomato
                topRank.ForeColor = Drawing.Color.Yellow
    
                'CondtionalFormatting Construtor
                Dim cf As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2))
                Dim cf1 As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), topRank, unary)
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf)
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf1)
                'OR
                'SetConditionalFormatting Overload
                'FpSpread1.ActiveSheetView.SetConditionalFormatting(cf, cf1)
            End Sub
    
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.UnaryComparisonOperator

    See Also