Spread Windows Forms 12.0 Product Documentation
FormatString Property (FilterBarCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > FilterBarCellType Class : FormatString Property
Gets or sets the format string used to format the value.
Syntax
'Declaration
 
Public Property FormatString As String
'Usage
 
Dim instance As FilterBarCellType
Dim value As String
 
instance.FormatString = value
 
value = instance.FormatString
public string FormatString {get; set;}
Example
This example sets the FormatString property.
FarPoint.Win.Spread.CellType.FilterBarCellType ct = new FarPoint.Win.Spread.CellType.FilterBarCellType();
ct.ShowDropDownMenuStrip = true;
ct.ShowEditor = true;
ct.ShowLabel = true;
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[0].BackColor = Color.Red;
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();
Dim ct As New FarPoint.Win.Spread.CellType.FilterBarCellType()
ct.ShowDropDownMenuStrip = True
ct.ShowEditor = True
ct.ShowLabel = True
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(0).BackColor = Color.Red
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()
See Also

Reference

FilterBarCellType Class
FilterBarCellType Members