Spread Silverlight Documentation
RuleCount Property
Example 


Gets the number of rule objects in the collection.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public ReadOnly Property RuleCount As System.Integer
'Usage
 
Dim instance As ConditionalFormat
Dim value As System.Integer
 
value = instance.RuleCount
[System.ComponentModel.DefaultValue()]
public System.int RuleCount {get;}

Property Value

The number of rule objects in the collection. The default value is 0.
Example
This example gets the number of rules.
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 style1 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style1.Background = new SolidColorBrush(Colors.Green);
GcSpreadSheet1.Sheets[0].ConditionalFormats.AddDuplicateRule(style1, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
GcSpreadSheet1.Sheets[0].Cells[3, 1].Text = GcSpreadSheet1.Sheets[0].ConditionalFormats.RuleCount.ToString();
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 style1 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style1.Background = New SolidColorBrush(Colors.Green)
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddDuplicateRule(style1, New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
GcSpreadSheet1.Sheets(0).Cells(3, 1).Text = GcSpreadSheet1.Sheets(0).ConditionalFormats.RuleCount.ToString()
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.