ClearColumnHeaderSpanCells Method

Removes all spans from the column headers.

Syntax

Visual Basic
C#

'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();

Visual Basic

'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()

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

Reference

SheetView Class
SheetView Members

User-Task Documentation

Creating a Span of Cells