Spread Windows Forms 8.0 Product Documentation
ColumnFooterEnhanced Field
Example 


Represents the enhanced style for column footer cells.
Syntax
'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;
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
Requirements

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

See Also

Reference

DefaultStyleCollection Class
DefaultStyleCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.