Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / StyleInfo Class / Background Property
Example


In This Topic
    Background Property (StyleInfo)
    In This Topic
    Gets or sets a Windows.UI.Xaml.Media.Brush object that describes the background for a cell.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Overridable Property Background As Brush
    'Usage
     
    Dim instance As StyleInfo
    Dim value As Brush
     
    instance.Background = value
     
    value = instance.Background
    [DefaultValue("")]
    public virtual Brush Background {get; set;}

    Property Value

    The Windows.UI.Xaml.Media.Brush object that describes the background for a cell.
    Example
    This example sets the Background 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;
    
    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.AverageRule.Create(GrapeCity.Xaml.SpreadSheet.Data.AverageConditionType.Above, style);
    rule.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
    gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
    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 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 s As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    Dim rule = GrapeCity.Xaml.SpreadSheet.Data.AverageRule.Create(GrapeCity.Xaml.SpreadSheet.Data.AverageConditionType.Above, Style)
    rule.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
    See Also