Spread Windows Forms 9.0 Product Documentation
ColumnFooterFlat Field
Example 


Represents the flat style for column footer cells.
Syntax
'Declaration
 
Public Shared ReadOnly ColumnFooterFlat As NamedStyle
'Usage
 
Dim value As NamedStyle
 
value = DefaultStyleCollection.ColumnFooterFlat
public static readonly NamedStyle ColumnFooterFlat
Example
This example sets the column footer style.
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;
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
Requirements

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

See Also

Reference

DefaultStyleCollection Class
DefaultStyleCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.