Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ConditionalFormat Class / ComparisonOperator Property
Example


In This Topic
    ComparisonOperator Property
    In This Topic
    Gets or sets the comparison operator for the conditional format.
    Syntax
    'Declaration
     
    Public Property ComparisonOperator As ComparisonOperator
    'Usage
     
    Dim instance As ConditionalFormat
    Dim value As ComparisonOperator
     
    instance.ComparisonOperator = value
     
    value = instance.ComparisonOperator
    public ComparisonOperator ComparisonOperator {get; set;}

    Property Value

    ComparisonOperator object containing the operator
    Example
    This example gets the format for the specified cell.
    FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle(); 
    FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle(); 
    FarPoint.Win.Spread.NamedStyle styleMild = new FarPoint.Win.Spread.NamedStyle(); 
    FarPoint.Win.Spread.NamedStyle styleWarm = new FarPoint.Win.Spread.NamedStyle(); 
    FarPoint.Win.Spread.NamedStyle styleHot = new FarPoint.Win.Spread.NamedStyle(); 
    styleCold.BackColor = Color.Blue; 
    styleCold.ForeColor = Color.White; 
    styleCool.BackColor = Color.Cyan; 
    styleMild.BackColor = Color.Lime; 
    styleWarm.BackColor = Color.Yellow; 
    styleHot.BackColor = Color.Red; 
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "32"); 
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55"); 
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75"); 
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85"); 
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85"); 
    
    fpSpread1.ActiveSheet.Cells[1, 1].Value = 38;
    
    FarPoint.Win.Spread.ConditionalFormat[]cf;  
    cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1); 
    foreach (FarPoint.Win.Spread.ConditionalFormat item in cf) 
    { 
          MessageBox.Show(item.ComparisonOperator.ToString()); 
    }
    
    Dim styleCold As New FarPoint.Win.Spread.NamedStyle
    Dim styleCool As New FarPoint.Win.Spread.NamedStyle
    Dim styleMild As New FarPoint.Win.Spread.NamedStyle
    Dim styleWarm As New FarPoint.Win.Spread.NamedStyle
    Dim styleHot As New FarPoint.Win.Spread.NamedStyle
    styleCold.BackColor = Color.Blue
    styleCold.ForeColor = Color.White
    styleCool.BackColor = Color.Cyan
    styleMild.BackColor = Color.Lime
    styleWarm.BackColor = Color.Yellow
    styleHot.BackColor = Color.Red
    
    Dim co As New FarPoint.Win.Spread.ComparisonOperator
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, co.LessThan, "32")
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, co.Between, "32", "55")
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, co.Between, "55", "75")
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, co.Between, "75", "85")
    fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, co.GreaterThan, "85")
    
    fpSpread1.ActiveSheet.Cells(1, 1).Value = 38
    
    Dim cf As FarPoint.Win.Spread.ConditionalFormat()
    Dim item As New FarPoint.Win.Spread.ConditionalFormat
    cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1)
    For Each item In cf
          MessageBox.Show(item.ComparisonOperator.ToString())
    Next
    See Also