Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / DefaultStyleCollection Class / CornerFooterFlat Field
Example


In This Topic
    CornerFooterFlat Field
    In This Topic
    Represents the flat style for corner footer cells.
    Syntax
    'Declaration
     
    Public Shared ReadOnly CornerFooterFlat As NamedStyle
    'Usage
     
    Dim value As NamedStyle
     
    value = DefaultStyleCollection.CornerFooterFlat
    public static readonly NamedStyle CornerFooterFlat
    Example
    This example sets the corner 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", "CornerFooterFlat");
    fpSpread1.NamedStyles.Add(backstyle);
    FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
    FarPoint.Win.Spread.SpreadSkin skin = new FarPoint.Win.Spread.SpreadSkin();
    skin.CornerFooterDefaultStyle = 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", "CornerFooterFlat")
    FpSpread1.NamedStyles.Add(backstyle)
    Dim sheetview As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
    Dim skin As New FarPoint.Win.Spread.SpreadSkin()
    skin.CornerFooterDefaultStyle = backstyle
    FpSpread1.Skin = skin
    See Also