Create Method (DateOccurringRule)

Creates a data occurring rule with specified parameters.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function Create( _
   ByVal op As DateOccurringType, _
   ByVal style As StyleInfo _
) As DateOccurringRule

'Usage
 
Dim op As DateOccurringType
Dim style As StyleInfo
Dim value As DateOccurringRule
 
value = DateOccurringRule.Create(op, style)

public static DateOccurringRule Create( 
   DateOccurringType op,
   StyleInfo style
)

Parameters

op: The DateOccurringType data occurring rule.
style: The style that is set by the rule.

Return Value

The new data occurring rule.

Example

This example uses the date rule to compare the cell range to the following week.

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.DateOccurringRule.Create(GrapeCity.Windows.SpreadSheet.Data.DateOccurringType.NextWeek, 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, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now);
gcSpreadSheet1.Sheets[0].SetValue(1, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(1));
gcSpreadSheet1.Sheets[0].SetValue(2, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(5));
gcSpreadSheet1.Sheets[0].SetValue(3, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(6));
gcSpreadSheet1.Sheets[0].SetValue(4, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(7));
gcSpreadSheet1.Sheets[0].SetValue(5, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(8));
gcSpreadSheet1.Invalidate();

VB.NET

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.DateOccurringRule.Create(GrapeCity.Windows.SpreadSheet.Data.DateOccurringType.NextWeek, 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, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now)
GcSpreadSheet1.Sheets(0).SetValue(1, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(1))
GcSpreadSheet1.Sheets(0).SetValue(2, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(5))
GcSpreadSheet1.Sheets(0).SetValue(3, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(6))
GcSpreadSheet1.Sheets(0).SetValue(4, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(7))
GcSpreadSheet1.Sheets(0).SetValue(5, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, DateTime.Now.AddDays(8))
GcSpreadSheet1.Invalidate()

Reference

DateOccurringRule Class
DateOccurringRule Members