Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / Label Property
Example


In This Topic
    Label Property (Column)
    In This Topic
    Gets or sets the header label for this column.
    Syntax
    '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;
    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
    See Also