Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Column Class / Background Property
Example


In This Topic
    Background Property (Column)
    In This Topic
    Gets or sets the background for a column.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Property Background As Brush
    'Usage
     
    Dim instance As Column
    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 column. The default value is null, which means the background color is not specified and the column inherits the background color from the worksheet.
    Example
    This example sets the Background property.
    for (int i = 0; i < gcSpreadSheet1.Sheets[0].RowCount; i++)
    {
        gcSpreadSheet1.Sheets[0].Columns[1].SetValue(i, i);
    }
    gcSpreadSheet1.Sheets[0].Columns[1].Background = new SolidColorBrush(Colors.Gray);
    gcSpreadSheet1.Sheets[0].Columns[1].Foreground = new SolidColorBrush(Colors.Red);
    gcSpreadSheet1.Sheets[0].Columns[1].Formatter = new GeneralFormatter("0.00");
    gcSpreadSheet1.Sheets[0].Columns[1].FontSize = 12;
    gcSpreadSheet1.Sheets[0].Columns[1].FontWeight = FontWeights.Bold;
    gcSpreadSheet1.Sheets[0].Columns[1].BorderBottom = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Columns[1].BorderTop = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Columns[1].BorderLeft = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    gcSpreadSheet1.Sheets[0].Columns[1].BorderRight = new BorderLine(Colors.Green, BorderLineStyle.Thin);
    For i As Integer = 0 To GcSpreadSheet1.Sheets(0).RowCount - 1
        GcSpreadSheet1.Sheets(0).Columns(1).SetValue(i, i)
    Next
    GcSpreadSheet1.Sheets(0).Columns(1).Background = New SolidColorBrush(Colors.Gray)
    GcSpreadSheet1.Sheets(0).Columns(1).Foreground = New SolidColorBrush(Colors.Red)
    GcSpreadSheet1.Sheets(0).Columns(1).Formatter = New GeneralFormatter("0.00")
    GcSpreadSheet1.Sheets(0).Columns(1).FontSize = 12
    GcSpreadSheet1.Sheets(0).Columns(1).FontWeight = FontWeights.Bold
    GcSpreadSheet1.Sheets(0).Columns(1).BorderBottom = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    GcSpreadSheet1.Sheets(0).Columns(1).BorderTop = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    GcSpreadSheet1.Sheets(0).Columns(1).BorderLeft = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    GcSpreadSheet1.Sheets(0).Columns(1).BorderRight = New BorderLine(Colors.Green, BorderLineStyle.Thin)
    See Also