Spread WPF Documentation
Create Method (DateOccurringRule)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > DateOccurringRule Class : Create Method
The DateOccurringType data occurring rule.
The style that is set by the rule.
Creates a data occurring rule with specified parameters.
Syntax
'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 compares the dates in the 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();
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()
See Also

Reference

DateOccurringRule Class
DateOccurringRule Members