Formatter Property (Row)

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Formatter As IFormatter

'Usage
 
Dim instance As Row
Dim value As IFormatter
 
instance.Formatter = value
 
value = instance.Formatter

[System.ComponentModel.DefaultValue()]
public IFormatter Formatter {get; set;}

Property Value

The formatter for this row. The default value is null, which means that no formatter is set.

This example sets the Formatter property.

C#

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)

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Row Class
Row Members