Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AddColumnFooterSpanCell Method
Row index of cell to start span
Column index of cell to start span
Number of rows to span
Number of columns to span
Example


In This Topic
    AddColumnFooterSpanCell Method
    In This Topic
    Adds a span of cells to a column footer for a sheet.
    Syntax
    'Declaration
 
Public Sub AddColumnFooterSpanCell( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) 
    'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.AddColumnFooterSpanCell(row, column, rowCount, columnCount)
    public void AddColumnFooterSpanCell( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

    Parameters

    row
    Row index of cell to start span
    column
    Column index of cell to start span
    rowCount
    Number of rows to span
    columnCount
    Number of columns to span
    Example
    This example uses the AddColumnFooterSpanCell method. 
    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";
fpSpread1.Sheets[0].AddColumnFooterSpanCell(0, 0, 1, 2);
//fpSpread1.Sheets[0].ClearColumnFooterSpanCells();
    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
FpSpread1.Sheets(0).AddColumnFooterSpanCell(0, 0, 1, 2)
'FpSpread1.Sheets(0).ClearColumnFooterSpanCells()
    See Also

    Reference

    SheetView Class
    SheetView Members

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page