Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Top10Rule Class / Top10Rule Constructor
Example


In This Topic
    Top10Rule Constructor
    In This Topic
    Constructs a top 10 rule.
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New Top10Rule()
    public Top10Rule()
    Example
    This example creates a top 10 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);
    var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Colors.Yellow);
    
    GrapeCity.Windows.SpreadSheet.Data.Top10Rule test = new GrapeCity.Windows.SpreadSheet.Data.Top10Rule();
    test.Style = style2;
    test.Operator = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top;
    test.Rank = 2;
    test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);    
    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)
    Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Colors.Yellow)
    
    Dim test As New GrapeCity.Windows.SpreadSheet.Data.Top10Rule()
    test.Style = style2
    test.Operator = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top
    test.Rank = 2
    test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    See Also