LabelColor Property

Gets or sets the color of the label.

Syntax

Visual Basic
C#

'Declaration
 
Public Property LabelColor As Color

'Usage
 
Dim instance As FilterBarCellType
Dim value As Color
 
instance.LabelColor = value
 
value = instance.LabelColor

public Color LabelColor {get; set;}

Example

This example sets the LabelColor property.

FarPoint.Win.Spread.CellType.FilterBarCellType ct = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct.ShowDropDownMenuStrip = true;
ct.ShowEditor = true;
ct.ShowLabel = true;
ct.LabelColor = Color.BlueViolet;
ct.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
System.Globalization.DateTimeFormatInfo dtformat = new System.Globalization.DateTimeFormatInfo();
dtformat.ShortDatePattern = "yy/MM/dd";
dtformat.ShortTimePattern = "";
dtformat.LongTimePattern = "";
ct.DateTimeFormatInfo = dtformat;
ct.AutoFormat = true;
FarPoint.Win.Spread.CellType.FilterBarCellType ct1 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct1.ShowEditor = true;
ct1.ShowLabel = true;
ct1.FormatString = "dd";
ct1.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime;
ct1.AutoFormat = true;

FarPoint.Win.Spread.CellType.FilterBarCellType ct2 = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct2.ShowEditor = true;
ct2.ShowLabel = true;
System.Globalization.NumberFormatInfo num = new System.Globalization.NumberFormatInfo();
num.CurrencySymbol = "$";
num.CurrencyDecimalDigits = 3;
ct2.NumberFormatInfo = num;
ct2.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.Number;
ct2.AutoFormat = true;

fpSpread1.ActiveSheet.FilterBar.Cells[0].CellType = ct;

fpSpread1.ActiveSheet.FilterBar.Cells[1].CellType = ct1;
fpSpread1.ActiveSheet.FilterBar.Cells[1].BackColor = Color.Aqua;
fpSpread1.ActiveSheet.FilterBar.Cells[2].CellType = ct2;
fpSpread1.ActiveSheet.FilterBar.Cells[2].BackColor = Color.Yellow;
fpSpread1.ActiveSheet.ColumnHeader.Columns[0].Label = "DateTime";
fpSpread1.ActiveSheet.ColumnHeader.Columns[1].Label = "FormatString";
fpSpread1.ActiveSheet.ColumnHeader.Columns[2].Label = "Number";
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
fpSpread1.ActiveSheet.Cells[0, 1].CellType = new FarPoint.Win.Spread.CellType.DateTimeCellType();

Visual Basic

Dim ct As New FarPoint.Win.Spread.CellType.FilterBarCellType()
ct.ShowDropDownMenuStrip = True
ct.ShowEditor = True
ct.ShowLabel = True
ct.LabelColor = Color.BlueViolet
ct.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime
Dim dtformat As New System.Globalization.DateTimeFormatInfo()
dtformat.ShortDatePattern = "yy/MM/dd"
dtformat.ShortTimePattern = ""
dtformat.LongTimePattern = ""
ct.DateTimeFormatInfo = dtformat
ct.AutoFormat = True
Dim ct1 As New FarPoint.Win.Spread.CellType.FilterBarCellType()
ct1.ShowEditor = True
ct1.ShowLabel = True
ct1.FormatString = "dd"
ct1.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime
ct1.AutoFormat = True

Dim ct2 As New FarPoint.Win.Spread.CellType.FilterBarCellType()
ct2.ShowEditor = True
ct2.ShowLabel = True
Dim num As New System.Globalization.NumberFormatInfo()
num.CurrencySymbol = "$"
num.CurrencyDecimalDigits = 3
ct2.NumberFormatInfo = num
ct2.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.Number
ct2.AutoFormat = True
  
FpSpread1.ActiveSheet.FilterBar.Cells(0).CellType = ct

FpSpread1.ActiveSheet.FilterBar.Cells(1).CellType = ct1
FpSpread1.ActiveSheet.FilterBar.Cells(1).BackColor = Color.Aqua
FpSpread1.ActiveSheet.FilterBar.Cells(2).CellType = ct2
FpSpread1.ActiveSheet.FilterBar.Cells(2).BackColor = Color.Yellow
FpSpread1.ActiveSheet.ColumnHeader.Columns(0).Label = "DateTime"
FpSpread1.ActiveSheet.ColumnHeader.Columns(1).Label = "FormatString"
FpSpread1.ActiveSheet.ColumnHeader.Columns(2).Label = "Number"
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
FpSpread1.ActiveSheet.Cells(0, 1).CellType = New FarPoint.Win.Spread.CellType.DateTimeCellType()

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FilterBarCellType Class
FilterBarCellType Members