Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ClearColumnHeaderSpanCells Method
Example


In This Topic
    ClearColumnHeaderSpanCells Method
    In This Topic
    Removes all spans from the column headers.
    Syntax
    'Declaration
     
    Public Sub ClearColumnHeaderSpanCells() 
    'Usage
     
    Dim instance As SheetView
     
    instance.ClearColumnHeaderSpanCells()
    public void ClearColumnHeaderSpanCells()
    Example
    This example clears the header span.
    //Create Span
    fpSpread1.Sheets[0].ColumnHeader.Rows.Count = 2;
    fpSpread1.Sheets[0].AddColumnHeaderSpanCell(0, 0, 1, 2);
    //Clear Span 
    fpSpread1.Sheets[0].ClearColumnHeaderSpanCells();
    
    
    'Create the span
    FpSpread1.Sheets(0).ColumnHeader.Rows.Count = 2
    FpSpread1.Sheets(0).AddColumnHeaderSpanCell(0, 0, 1, 2)
    'Clear the span 
    FpSpread1.Sheets(0).ClearColumnHeaderSpanCells()
    
    See Also