ColumnFooterEnhanced Field | Spread Windows Forms 13.0 Product Documentation

ColumnFooterEnhanced Field

In This Topic

Represents the enhanced style for column footer cells.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared ReadOnly ColumnFooterEnhanced As NamedStyle

'Usage
 
Dim value As NamedStyle
 
value = DefaultStyleCollection.ColumnFooterEnhanced

public static readonly NamedStyle ColumnFooterEnhanced

Example

This example sets the column footer style.

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", "ColumnFooterEnhanced");
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", "ColumnFooterEnhanced")
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

Reference

DefaultStyleCollection Class
DefaultStyleCollection Members

Product Support Forum | Print this page