Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / SpecificTextRule Class / Create Method
The comparison operator.
The text for comparison.
The cell style.
Example


In This Topic
    Create Method (SpecificTextRule)
    In This Topic
    Creates a new text rule with the specified comparison operator, text, and style.
    Syntax
    'Declaration
     
    Public Shared Function Create( _
       ByVal op As TextComparisonOperator, _
       ByVal text As String, _
       ByVal style As StyleInfo _
    ) As SpecificTextRule
    'Usage
     
    Dim op As TextComparisonOperator
    Dim text As String
    Dim style As StyleInfo
    Dim value As SpecificTextRule
     
    value = SpecificTextRule.Create(op, text, style)
    public static SpecificTextRule Create( 
       TextComparisonOperator op,
       string text,
       StyleInfo style
    )

    Parameters

    op
    The comparison operator.
    text
    The text for comparison.
    style
    The cell style.

    Return Value

    The new text rule that is created.
    Example
    This example uses the Create method.
    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.SpecificTextRule.Create(GrapeCity.Xaml.SpreadSheet.Data.TextComparisonOperator.Contains, "test", style);          
    rule.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 10, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
    
    gcSpreadSheet1.Sheets[0].SetValue(0, 0, "testing");
    gcSpreadSheet1.Sheets[0].SetValue(1, 0, "test");
    gcSpreadSheet1.Sheets[0].SetValue(2, 0, "a");
    gcSpreadSheet1.Sheets[0].SetValue(3, 0, "t");
    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 rule = GrapeCity.Xaml.SpreadSheet.Data.SpecificTextRule.Create(GrapeCity.Xaml.SpreadSheet.Data.TextComparisonOperator.Contains, "test", style);   
    rule.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 10, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
    
    GcSpreadSheet1.Sheets(0).SetValue(0, 0, "testing")
    GcSpreadSheet1.Sheets(0).SetValue(1, 0, "test")
    GcSpreadSheet1.Sheets(0).SetValue(2, 0, "a")
    GcSpreadSheet1.Sheets(0).SetValue(3, 0, "t")
    See Also