Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / ConditionalFormat Class / AddDateOccurringRule Method
The DateOccurringType data occurring type.
The style that is set to the cell when the condition is met.
The cell ranges where the rule is applied.
Example


In This Topic
    AddDateOccurringRule Method
    In This Topic
    Adds the data occurring rule to the rule collection.
    Syntax
    'Declaration
     
    Public Function AddDateOccurringRule( _
       ByVal type As DateOccurringType, _
       ByVal style As StyleInfo, _
       ByVal ParamArray ranges() As CellRange _
    ) As DateOccurringRule
    'Usage
     
    Dim instance As ConditionalFormat
    Dim type As DateOccurringType
    Dim style As StyleInfo
    Dim ranges() As CellRange
    Dim value As DateOccurringRule
     
    value = instance.AddDateOccurringRule(type, style, ranges)
    public DateOccurringRule AddDateOccurringRule( 
       DateOccurringType type,
       StyleInfo style,
       params CellRange[] ranges
    )

    Parameters

    type
    The DateOccurringType data occurring type.
    style
    The style that is set to the cell when the condition is met.
    ranges
    The cell ranges where the rule is applied.

    Return Value

    Returns the new data occurring rule.
    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);
    GcSpreadSheet1.Sheets[0].ConditionalFormats.AddDateOccurringRule(GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek, style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
    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)
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddDateOccurringRule(GrapeCity.Xaml.SpreadSheet.Data.DateOccurringType.NextWeek, style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
    See Also