GrapeCity.Xaml.SpreadSheet.Data
Create Method (CellValueRule)
Example 


The comparison operator ComparisonOperator for the text rule.
The first object.
The second object.
The style that is set by the rule.
Creates a cell value data rule with specified parameters.
Syntax
'Declaration
 
Public Shared Function Create( _
   ByVal op As ComparisonOperator, _
   ByVal value1 As Object, _
   ByVal value2 As Object, _
   ByVal style As StyleInfo _
) As CellValueRule
'Usage
 
Dim op As ComparisonOperator
Dim value1 As Object
Dim value2 As Object
Dim style As StyleInfo
Dim value As CellValueRule
 
value = CellValueRule.Create(op, value1, value2, style)
public static CellValueRule Create( 
   ComparisonOperator op,
   object value1,
   object value2,
   StyleInfo style
)

Parameters

op
The comparison operator ComparisonOperator for the text rule.
value1
The first object.
value2
The second object.
style
The style that is set by the rule.

Return Value

The new cell value rule.
Example
This example creates a cell value rule.
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.CellValueRule.Create(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 2, 100, style);           
rule.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);

gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 45;
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 s As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
Dim rule = GrapeCity.Xaml.SpreadSheet.Data.CellValueRule.Create(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 2, 100, style)

rule.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 45
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

CellValueRule Class
CellValueRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options