Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / DateOccurringType Enumeration
Example Example


In This Topic
    DateOccurringType Enumeration
    In This Topic
    Specifies a condition for when a date occurs.
    Syntax
    'Declaration
     
    Public Enum DateOccurringType 
       Inherits System.Enum
    'Usage
     
    Dim instance As DateOccurringType
    public enum DateOccurringType : System.Enum 
    Members
    MemberDescription
    Last7DaysSpecifies the last seven days.
    LastMonthSpecifies last month.
    LastWeekSpecifies last week.
    NextMonthSpecifies next month.
    NextWeekSpecifies next week.
    ThisMonthSpecifies this month.
    ThisWeekSpecifies this week.
    TodaySpecifies today.
    TomorrowSpecifies tomorrow.
    YesterdaySpecifies yesterday.
    Example
    This example uses the DateOccurringType enumeration.
    var style = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style.Background = new SolidColorBrush(Windows.UI.Colors.Blue);
    style.BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red);
    style.BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red);
    style.BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red);
    style.BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red);
    var style1 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style1.Background = new SolidColorBrush(Windows.UI.Colors.Green);
    var style2 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
    
    var rule = GrapeCity.Xaml.SpreadSheet.Data.DateOccurringRule.Create(GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek, style);           
    rule.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 10, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(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));
    Dim style As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style.Background = New SolidColorBrush(Windows.UI.Colors.Blue)
    style.BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red)
    style.BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red)
    style.BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red)
    style.BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red)
    Dim style1 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style1.Background = New SolidColorBrush(Windows.UI.Colors.Green)
    Dim style2 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
    
    Dim rule = GrapeCity.Xaml.SpreadSheet.Data.DateOccurringRule.Create(GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek, style)
    rule.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 10, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(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))
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType

    See Also