Label Property (Column)

Gets or sets the header label for this column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Label As String

'Usage
 
Dim instance As Column
Dim value As String
 
instance.Label = value
 
value = instance.Label

public string Label {get; set;}

Property Value

String containing the label for this column

Remarks

Column objects returned by the Columns object's Default property and Column objects in the column or row headers do not have a label.

This is not the same as the automatic text. For information on the automatic text that appears in a column row, refer to ColumnHeader class AutoText and AutoTextIndex.

Example

This example creates a spreadsheet with 10 columns and 20 rows. A Column object is created and assigned to the second column of the spreadsheet. The column header is given custom text via the Label property, which is also returned to a text box.

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Label="FarPoint";
TextBox1.Text=mycol.Label;

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Label="FarPoint"
TextBox1.Text=mycol.Label

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Column Class
Column Members
Default Property