GrapeCity.Xaml.SpreadSheet.Data
AddDateOccurringRule Method
Example 


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.
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)})
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

ConditionalFormat Class
ConditionalFormat Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options