GrapeCity.Xaml.SpreadSheet.Data
Background Property (Column)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Column Class : Background Property
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 Windows.UI.Xaml.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 uses 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(Windows.UI.Colors.Gray);
gcSpreadSheet1.Sheets[0].Columns[1].Foreground = new SolidColorBrush(Windows.UI.Colors.Red);
gcSpreadSheet1.Sheets[0].Columns[1].Formatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00");
gcSpreadSheet1.Sheets[0].Columns[1].FontSize = 12;
gcSpreadSheet1.Sheets[0].Columns[1].FontWeight = Windows.UI.Text.FontWeights.Bold;
gcSpreadSheet1.Sheets[0].Columns[1].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Columns[1].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Columns[1].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin);
gcSpreadSheet1.Sheets[0].Columns[1].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.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(Windows.UI.Colors.Gray)
GcSpreadSheet1.Sheets(0).Columns(1).Foreground = New SolidColorBrush(Windows.UI.Colors.Red)
GcSpreadSheet1.Sheets(0).Columns(1).Formatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("0.00")
GcSpreadSheet1.Sheets(0).Columns(1).FontSize = 12
GcSpreadSheet1.Sheets(0).Columns(1).FontWeight = Windows.UI.Text.FontWeights.Bold
GcSpreadSheet1.Sheets(0).Columns(1).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
GcSpreadSheet1.Sheets(0).Columns(1).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
GcSpreadSheet1.Sheets(0).Columns(1).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
GcSpreadSheet1.Sheets(0).Columns(1).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thin)
See Also

Reference

Column Class
Column Members