Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Row Class / Background Property
Example


In This Topic
    Background Property (Row)
    In This Topic
    Gets or sets the background for a row.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Property Background As Brush
    'Usage
     
    Dim instance As Row
    Dim value As Brush
     
    instance.Background = value
     
    value = instance.Background
    [DefaultValue("")]
    public Brush Background {get; set;}

    Property Value

    A System.Windows.Media.Brush object that describes the background for cells in this row. The default value is null, which means that no color is set for the row.
    Example
    This example sets the Background property.
    for (int i = 0; i < gcSpreadSheet1.Sheets[0].ColumnCount; i++)
                {
                    gcSpreadSheet1.Sheets[0].Rows[1].SetValue(i, i);
                }
    gcSpreadSheet1.Sheets[0].Rows[1].Background = new SolidColorBrush(Colors.Gray);
    gcSpreadSheet1.Sheets[0].Rows[1].Foreground = new SolidColorBrush(Colors.Red);
    gcSpreadSheet1.Sheets[0].Rows[1].Formatter = new GeneralFormatter("0.00");
    gcSpreadSheet1.Sheets[0].Rows[1].FontSize = 12;
    gcSpreadSheet1.Sheets[0].Rows[1].FontWeight = FontWeights.Bold;
    gcSpreadSheet1.Sheets[0].Rows[1].BorderBottom = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Rows[1].BorderTop = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Rows[1].BorderLeft = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Rows[1].BorderRight = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    For i As Integer = 0 To gcSpreadSheet1.Sheets(0).ColumnCount - 1
        gcSpreadSheet1.Sheets(0).Rows(1).SetValue(i, i)
    Next
    gcSpreadSheet1.Sheets(0).Rows(1).Background = New SolidColorBrush(Colors.Gray)
    gcSpreadSheet1.Sheets(0).Rows(1).Foreground = New SolidColorBrush(Colors.Red)
    gcSpreadSheet1.Sheets(0).Rows(1).Formatter = New GeneralFormatter("0.00")
    gcSpreadSheet1.Sheets(0).Rows(1).FontSize = 12
    gcSpreadSheet1.Sheets(0).Rows(1).FontWeight = FontWeights.Bold
    gcSpreadSheet1.Sheets(0).Rows(1).BorderBottom = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    gcSpreadSheet1.Sheets(0).Rows(1).BorderTop = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    gcSpreadSheet1.Sheets(0).Rows(1).BorderLeft = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    gcSpreadSheet1.Sheets(0).Rows(1).BorderRight = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    See Also