Spread Silverlight Documentation
DuplicateRule Constructor
Example 


Constructs a unique rule.
Syntax
'Declaration
 
Public Function New()
'Usage
 
Dim instance As New DuplicateRule()
public DuplicateRule()
Example
This example creates a duplicate rule.
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = 3;       

private void button1_Click(object sender, RoutedEventArgs e)
        {
            GrapeCity.Windows.SpreadSheet.Data.StyleInfo style1 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
            style1.Background = new SolidColorBrush(Colors.Green);
            GrapeCity.Windows.SpreadSheet.Data.DuplicateRule test = new GrapeCity.Windows.SpreadSheet.Data.DuplicateRule();
            test.Style = style1;
            test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
            gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);             
        }
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = 3

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        Dim style1 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
        style1.Background = New SolidColorBrush(Colors.Green)
        Dim test As New GrapeCity.Windows.SpreadSheet.Data.DuplicateRule()
        test.Style = style1
        test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
        GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

DuplicateRule Class
DuplicateRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.