Spread Silverlight Documentation
Color Property (DataBarRule)
Example 


Gets or sets the postive fill color of the data bar set rule.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Color As System.Windows.Media.Color
'Usage
 
Dim instance As DataBarRule
Dim value As System.Windows.Media.Color
 
instance.Color = value
 
value = instance.Color
[System.ComponentModel.DefaultValue()]
public System.Windows.Media.Color Color {get; set;}
Example
This example uses the Color property.
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = -3; 

GrapeCity.Windows.SpreadSheet.Data.DataBarRule test = new GrapeCity.Windows.SpreadSheet.Data.DataBarRule();
test.Color = Colors.Magenta;
test.ShowBarOnly = true;
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 = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = -3

Dim test As New GrapeCity.Windows.SpreadSheet.Data.DataBarRule()
test.Color = Colors.Magenta
test.ShowBarOnly = True
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
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

DataBarRule Class
DataBarRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.