ColumnFooterDefaultStyle Property

Visual Basic
C#

'Declaration
 
Public Property ColumnFooterDefaultStyle As NamedStyle

'Usage
 
Dim instance As SpreadSkin
Dim value As NamedStyle
 
instance.ColumnFooterDefaultStyle = value
 
value = instance.ColumnFooterDefaultStyle

public NamedStyle ColumnFooterDefaultStyle {get; set;}

This example sets the column footer style.

C#

fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the column footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.ForeColor = Color.Purple;
fpSpread1.Sheets[0].ColumnFooter.Columns[12].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 12].RowSpan = 2;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 0].Value = "test";
FarPoint.Win.Spread.NamedStyle backstyle = new FarPoint.Win.Spread.NamedStyle("NewStyle", "ColumnFooterFlat");
fpSpread1.NamedStyles.Add(backstyle);
FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
FarPoint.Win.Spread.SpreadSkin skin = new FarPoint.Win.Spread.SpreadSkin();
skin.ColumnFooterDefaultStyle = backstyle;
fpSpread1.Skin = skin;

Visual Basic

FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 15
' Show the footer.
FpSpread1.Sheets(0).ColumnFooter.Visible = true
FpSpread1.Sheets(0).ColumnFooter.RowCount = 2
FpSpread1.Sheets(0).ColumnFooter.DefaultStyle.ForeColor = Color.Purple
FpSpread1.Sheets(0).ColumnFooter.Columns(12).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left
FpSpread1.Sheets(0).ColumnFooter.Cells(0, 12).RowSpan = 2
FpSpread1.Sheets(0).ColumnFooter.Cells(0, 0).Value = "test
Dim backstyle As New FarPoint.Win.Spread.NamedStyle("NewStyle", "ColumnFooterFlat")
FpSpread1.NamedStyles.Add(backstyle)
Dim sheetview As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
Dim skin As New FarPoint.Win.Spread.SpreadSkin()
skin.ColumnFooterDefaultStyle = backstyle
FpSpread1.Skin = skin

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SpreadSkin Class
SpreadSkin Members