Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / DateOccurringRule Class / DateOccurringRule Constructor
Example


In This Topic
    DateOccurringRule Constructor
    In This Topic
    Constructs a data occurring rule.
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New DateOccurringRule()
    public DateOccurringRule()
    Example
    This example creates a date occurring rule.
    gcSpreadSheet1.Sheets[0].SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now);
    gcSpreadSheet1.Sheets[0].SetValue(1, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(1));
    gcSpreadSheet1.Sheets[0].SetValue(2, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(5));
    gcSpreadSheet1.Sheets[0].SetValue(3, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(6));
    gcSpreadSheet1.Sheets[0].SetValue(4, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(7));
    gcSpreadSheet1.Sheets[0].SetValue(5, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(8));
    var style2 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
    
    GrapeCity.Xaml.SpreadSheet.Data.DateOccurringRule test = new GrapeCity.Xaml.SpreadSheet.Data.DateOccurringRule();
    test.Style = style2;
    test.Operator = GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek;
    test.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);
    GcSpreadSheet1.Sheets(0).SetValue(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now)
    GcSpreadSheet1.Sheets(0).SetValue(1, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(1))
    GcSpreadSheet1.Sheets(0).SetValue(2, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(5))
    GcSpreadSheet1.Sheets(0).SetValue(3, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(6))
    GcSpreadSheet1.Sheets(0).SetValue(4, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(7))
    GcSpreadSheet1.Sheets(0).SetValue(5, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(8))
    Dim style2 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
    
    Dim test As New GrapeCity.Xaml.SpreadSheet.Data.DateOccurringRule()
    test.Style = style2
    test.Operator = GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek
    test.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    See Also