Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / FilterBarCellType Class / FormatString Property
Example


In This Topic
    FormatString Property (FilterBarCellType)
    In This Topic
    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