Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Top10ConditionType Enumeration
Example Example


In This Topic
    Top10ConditionType Enumeration
    In This Topic
    Specifies the type for the top 10 condition.
    Syntax
    'Declaration
     
    Public Enum Top10ConditionType 
       Inherits System.Enum
    'Usage
     
    Dim instance As Top10ConditionType
    public enum Top10ConditionType : System.Enum 
    Members
    MemberDescription
    BottomSpecifies the bottom condition.
    TopSpecifies the top condition.
    Example
    This example uses the Top10ConditionType enumeration.
    Dim style As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
    style.Background = New SolidColorBrush(Colors.Blue)
    style.BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
    style.BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
    style.BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
    style.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
    Dim style1 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
    style1.Background = New SolidColorBrush(Colors.Green)
    Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Colors.Yellow)
    
    Dim rule = GrapeCity.Windows.SpreadSheet.Data.Top10Rule.Create(GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top, 2, style);   
    rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 10, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
    
    GcSpreadSheet1.Sheets(0).SetValue(0, 0, 1)
    GcSpreadSheet1.Sheets(0).SetValue(1, 0, 50)
    GcSpreadSheet1.Sheets(0).SetValue(2, 0, 11)
    GcSpreadSheet1.Sheets(0).SetValue(3, 0, 5)
    GcSpreadSheet1.Invalidate()
    var style = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
    style.Background = new SolidColorBrush(Colors.Blue);
    style.BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
    style.BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
    style.BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
    style.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
    var style1 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
    style1.Background = new SolidColorBrush(Colors.Green);
    var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Colors.Yellow);
    
    var rule = GrapeCity.Windows.SpreadSheet.Data.Top10Rule.Create(GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top, 2, style);
    rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 10, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
    
    gcSpreadSheet1.Sheets[0].SetValue(0, 0, 1);
    gcSpreadSheet1.Sheets[0].SetValue(1, 0, 50);
    gcSpreadSheet1.Sheets[0].SetValue(2, 0, 11);
    gcSpreadSheet1.Sheets[0].SetValue(3, 0, 5);
    gcSpreadSheet1.Invalidate();
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType

    See Also