Background Property (Row)

In This Topic

Gets or sets the background for a row.

Syntax

Visual Basic
C#

'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);

VB.NET

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)

Reference

Row Class
Row Members

Product Support Forum | Print this page