Spread Silverlight Documentation
AddUniqueRule Method
Example 


The style that is applied to the cell.
The cell ranges where the rule is applied.
Adds a unique rule to the rule collection.
Syntax
'Declaration
 
Public Function AddUniqueRule( _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As UniqueRule
'Usage
 
Dim instance As ConditionalFormat
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As UniqueRule
 
value = instance.AddUniqueRule(style, ranges)
public UniqueRule AddUniqueRule( 
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

style
The style that is applied to the cell.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new unique rule.
Example
This example creates a unique 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;
GrapeCity.Windows.SpreadSheet.Data.StyleInfo style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddUniqueRule(style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
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
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddUniqueRule(style2, New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
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

ConditionalFormat Class
ConditionalFormat Members

 

 


Copyright © GrapeCity, inc. All rights reserved.