ColumnHeader Property (FpSpread)

Gets the column headers in the Spread component.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property ColumnHeader As ColumnHeader

'Usage
 
Dim instance As FpSpread
Dim value As ColumnHeader
 
value = instance.ColumnHeader

public ColumnHeader ColumnHeader {get;}

Property Value

ColumnHeader object containing the column headers in the currently selected sheet

Remarks

This property is available at run time only.

Example

This example creates a spreadsheet with three column header rows, displays numbers in the first row, aligns the numbers to the right side of the header and changes its background color to red.

FpSpread1.ColumnHeader.AutoText=FarPoint.Web.Spread.HeaderAutoText.Numbers;
FpSpread1.ColumnHeader.RowCount=3;
FpSpread1.ColumnHeader.AutoTextIndex=0;
FpSpread1.ColumnHeader.AlternatingRows[0].BackColor=Color.Red;
FpSpread1.ColumnHeader.AlternatingRows[0].HorizontalAlign=HorizontalAlign.Right;

Visual Basic

FpSpread1.ColumnHeader.AutoText=FarPoint.Web.Spread.HeaderAutoText.Numbers
FpSpread1.ColumnHeader.RowCount=3
FpSpread1.ColumnHeader.AutoTextIndex=0
FpSpread1.ColumnHeader.AlternatingRows(0).BackColor=Color.Red
FpSpread1.ColumnHeader.AlternatingRows(0).HorizontalAlign=HorizontalAlign.Right

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
RowHeader Property

User-Task Documentation

Customizing the Appearance of Headers